Thread: text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Kevin B
 
Posts: n/a
Default text

Copy the data in column A, move to the cell where you want the data to start
in and click on EDIT in the menu, select PASTE SPECIAL. Locate the
TRANSPOSE checkbox and check it off. Click OK to exit and delete the data in
Column A.

Viola!
--
Kevin Backmann


"Chris" wrote:

I entered text in column A and 5 rows
I want to change that information that I entered in A1, A2,A3,etc
to go to A1,B1,C1,D1,etc.
Can you help