Forum Discussion
moving multiple values in the same cell to a new one
Hi, it worked well on most cells, thanks!
I wonder what is different in the cells it did not work on
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!
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.
Celia_Alves , it looks like source data was copy/pasted from web. If only one comma Excel interprets it as thousand separator and paste the value as number. If few commas - as text.
If so, tasks becomes more interesting.
Roy_lavi , could you give the sample of the cell on which it doesn't work?
