Select A1:A5 Copy
Right-click on A2 Paste special Check "Transpose" OK
Delete col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Chris" wrote in message
...
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