Excel 2007 : Text to columns

[nightcrawler-jay]

Good morning, I need assisatnce. I have text going down in column A1, A2, A3 and so on but want to have the text running A, B, C, D, E and so on. I got it right once but am struggling now.

Please help

[ConneXionLost]

Hi jay,

Highlight and copy your text, then select the first cell where you want the text to go. Use Ctrl-Alt-V and select "Transpose".

Cheers,

[nightcrawler-jay]

Thanks alot