Dave Stone
asked on
Excel - Combine Columns
Hello,
I have an Excel file that I would like to combine columns A and B and add a dash between the two. I have tried using all the “tricks” I know but cannot seem to pull it off. For example, column A is 15544 and column B is 21. I would like this to become 15544-21. Is this possible? I have attached a file as an example.
Thank you
Example.xlsx
I have an Excel file that I would like to combine columns A and B and add a dash between the two. I have tried using all the “tricks” I know but cannot seem to pull it off. For example, column A is 15544 and column B is 21. I would like this to become 15544-21. Is this possible? I have attached a file as an example.
Thank you
Example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=A3&"-"&B3
Run the MergeAB macro that you'll find in Module1 or press Ctrl+Shift+M.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks to all! Perfect!
You're welcome!