how do I change the order of a colum

  • Thread starter Thread starter Yossy
  • Start date Start date
Y

Yossy

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

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

thanks a bunch
 
If they are all in one cell and you want to retain them in one cell then you
can do Edit|Replace (CTRL-H):

Find what: , (comma)
Replace with: CTRL-J

Then click on Replace. You might need to adjust the row height, and format
the cell for word-wrap.

Hope this helps.

Pete
 
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
 
thanks got it.

Mike H said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Follow up area under the curve 2
Scrabble Value calculation for Welsh words 0
min if horizontal 0
Functions in a worksheet for 2003 5
How do I sum cells by refering to discrete values? 7
Subtotaling 1
Question about Combin function 3
how do i do this in excel ? 3

Back
Top