Thread: Text to Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
KKD KKD is offline
external usenet poster
 
Posts: 31
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