| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to merge rows of data in 2 columns into 1 col.
I have 199 rolws of data in 2 cols and want to merge it into one col. for
printing lables. Excels instructions tell only how to merge 1 row, 2 cols into 1 col. How do I do this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to merge rows of data in 2 columns into 1 col.
=A1&" "&B1
copy down, then copy and paste special as values in place -- Regards, Peo Sjoblom (No private emails please) "Pianoman" wrote in message ... I have 199 rolws of data in 2 cols and want to merge it into one col. for printing lables. Excels instructions tell only how to merge 1 row, 2 cols into 1 col. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with Converting Rows of data into 2 columns | Excel Worksheet Functions | |||
| Data in table, may need to convert to columns with OFFSET? | Excel Discussion (Misc queries) | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| merge data from multiple columns to single column | Excel Worksheet Functions | |||
Linear Mode
