Hello i have a question.
How can i separate a cell in multiple cells to the right by using as a criteria "," ?
First example goes like this 64585868676, 4859859898569, 58595895
The second criteria is a little bit more complex.
Let's say i have two addresses like:
Garden avenue, Athens, 15562, Skra 55, Holargos, 16785
I would like to separate to the right the addresses like
Column A Column B Column C
Garden avenue Athens 15562
and the second address to be printed in a separate sheet. I don't care to know how to create a separate sheet, but how to take the value and paste it in there.
Could anyone help?
Thanks in advance