Thread: Text to Columns
View Single Post
  #1  
Old March 31st, 2010, 10:31 PM posted to microsoft.public.excel.newusers
KKD
external usenet poster
 
Posts: 32
Default 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