Forum Discussion
moving multiple values in the same cell to a new one
Hello
I have a long list (column) of multiple values and I am looking for an easier way to cut one value or more to another cell.
In other words, I need to seperate two or more values from the same cell so that each value has it's own cell.
for example
I have this short list with two or more values in each cell
| 148,111 |
| 42,43,56 |
| 77,121 |
| 44,45,74 |
| 66,109,84 |
| 79,65,95 |
| 42,101,130 |
and I want to make it like this
| 148 | 111 | |
| 42 | 43 | 56 |
| 77 | 121 | |
| 44 | 45 | 74 |
| 66 | 109 | 84 |
| 79 | 65 | 95 |
| 42 | 101 | 130 |
of course, with out cutting and pasting....
thanks allot!
Roy
Hi, it worked well on most cells, thanks!
I wonder what is different in the cells it did not work on
18 Replies
Select your column
Go to Tab Data
Click button "Text to Columns" (on Data Tools group)
On the dialogue box that pops up, choose "Delimited"
click Next
put a checkmark in "comma" (only)
click next
Click Finish
Let me know if this works. Good luck!
- Roy_laviCopper Contributor
Hi, it worked well on most cells, thanks!
I wonder what is different in the cells it did not work on
I tested here by copying the data from your post and the same happened here. It seems that some of the comas are being interpreted as the thousands separator, and not a text comma. You can see that if you select your column and format as general, or text, or number.
- SergeiBaklanDiamond Contributor
Roy_lavi , you may use Data->Text to Columns on ribbon