View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yossy Yossy is offline
external usenet poster
 
Posts: 127
Default how do I change the order of a colum

thanks got it.

"Mike H" wrote:

Hi,

Two stages.

1. Select the cell then
Data|Text to columns
Delimited
Next
Check comma
Finish

2. Select the row of data then
Copy
Select a cell outside the range
Edit|Paste special
Check Transpose
OK

Mike

"Yossy" wrote:

I have 1,2,3,4,5,6

How do I change them to this
1
2
3
4
5
6

thanks a bunch