I have 1,2,3,4,5,6 How do I change them to this 1 2 3 4 5 6 thanks a bunch
P Pete_UK Nov 5, 2008 #2 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
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
M Mike H Nov 5, 2008 #3 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
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
Y Yossy Nov 5, 2008 #4 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...
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...
