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
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.
BTW
when I paste to excel from PDF copy (which caused the above fault) you can 'special paste' and choose 'unicode text' it paste it just like I need it
Roy_lavi , with copy/paste from PDF you may combine both steps. For example, in PDF you have
which you paste to Excel (just Ctrl+V)
It looks like
first value is number. Here click Ctrl and select
Here on second step select Comma and click Finish.
That's all, you have what you'd like to have
So, the error accured in just a few cells, so I changed the commas to spaces and set the delimiters to space
thank you very much
If you had to do this for a big quantity of cell, you could do the following:
Then, apply the previous process to column B.
