Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Join cell data in two columns
Hey all,
This is probably simpler than I think but then again I am a newbie at macros or anything programming related. What I am looking for is an Excel macro that joins (not merges) data from two cells in different columns. So, basically the opposite of Text to columns. And I need it to do this for as many rows as needed until there is nothing left to join. Below is an example: Column 1 Column 2 23 Whatever St. Suite 2 87 Nowhere Rd. #201 So, now I just want column 1 to read: 23 Whatever St. Suite 2 87 Nowhere Rd. #201 This would be a huge help so thank you to all in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I join 3 separate columns of dates | Excel Worksheet Functions | |||
Join multiple rows into columns | Excel Discussion (Misc queries) | |||
Join multiple rows into columns | Excel Discussion (Misc queries) | |||
Is it possible to join columns where there is a match? | Excel Programming | |||
join columns, keep both values | New Users to Excel |