+ Reply to Thread
Results 1 to 10 of 10

Changes to Concatenate Macro

  1. #1
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Changes to Concatenate Macro

    http://www.excelforum.com/excel-prog...ate-macro.html Previous post for original macro created.

    Changes:
    macro breaks if range A only has one line of data
    Can output be placed at ,9 (column H) instead of ,6?
    **Can Astricks, dashes be excluded from the concatenate function?
    Can the ouptut for the count of the charaters be output to ,10 instead of ,8?
    Can the output line populate in ,8 the range from column A without the dash?

    Thank you in advance

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,464

    Re: Changes to Concatenate Macro

    ,9 (column H) - ,9 is "I" , 8 is "H"

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Changes to Concatenate Macro

    Can the output to ,8 (column H) be the number in Column A without the dashes?
    Output current output in ,8 (column H) to be ,9 (Column I)
    One additional item. Can you do this same forumulas for the Short text in Column F also?

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,464

    Re: Changes to Concatenate Macro

    Not sure just what is in column A - is the same number repeated, or do you want to concatenate all the values together?

    And where would you want the concatenated short text from column F placed?

  5. #5
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Changes to Concatenate Macro

    column A is the same number repeated. Below is an example.

    0405-1771
    0405-1771
    0405-1771
    0405-1771

  6. #6
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Changes to Concatenate Macro

    Actually the last request for the short text from column F will just need to populate the last description in the array. No concatenation needed.

  7. #7
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,464

    Re: Changes to Concatenate Macro

    Try this - it puts the last value from the group in column F into column G (you never said where to put that value....)

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Changes to Concatenate Macro

    I am testing the macro on the Test1 data I attached in the previous thread. http://www.excelforum.com/excel-prog...ate-macro.html

    When I do this, I get a Type mistach error.

    Could you put the result in Column I. That way both long and short descriptions are in the same column.

  9. #9
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,464

    Re: Changes to Concatenate Macro

    This worked for me:

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    06-13-2012
    Location
    ND
    MS-Off Ver
    Excel 2010
    Posts
    152

    Re: Changes to Concatenate Macro

    Works awesome Thank you so much. I will be able to make a few tweaks now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help - Possible Macro or?? Concatenate + If formula?
    By kbee859 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2014, 10:07 AM
  2. Need Macro for Concatenate If
    By apro in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2013, 11:03 AM
  3. need to Concatenate two columns by a macro
    By rsami in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-29-2013, 07:06 AM
  4. [SOLVED] [SOLVED] Concatenate Macro
    By osaka78 in forum Excel General
    Replies: 6
    Last Post: 04-09-2006, 08:40 AM
  5. [SOLVED] Concatenate Macro
    By mully in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-04-2006, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1