Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Text to Columns
I have data coming in that is on two rows, I want to move the lower row to be
on a single line with its corresponding data, is there a simple way to do this? Ex: 12345 June July Aug Johnson I want the "Johnson" piece of data to be on the same row. 12345 June July Aug Johnson I have hundreds of pages I am bringing in so I want to be able to change all data at once. -- KKD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
help with sorting text in columns to match other columns | Excel Discussion (Misc queries) | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |