I have a column of cells in excel which contain mails, some only contain one mail as they should but others, have more than one email per cell in this format:
email@example.com, firstname.lastname@example.org, email@example.com
What I want to achieve is getting them like this:
firstname.lastname@example.org email@example.com firstname.lastname@example.org
I´m guessing (don´t take my word on it) you could do some kind of if statement along the lines of
if (cell contains ", ") get string from ", " to ", " and paste somehow else "b1"
You may be screaming at your screen right now :) (or laughing) but it´s just how would approach it, no idea of the functions to be used or if it is even possible this way.
So if you have any ideas I appreciate it!!
Just in case, I want to do a csv out of this file so, any workaround that would get this done would do...
Thanks in advance!
BTW I hope I have explained the problem clear enough if not please ask for clarifications!
EDIT: The problem is actually solved, I gave in and did it one by one, the one method that never fails you :) Iwpuld appreciate any ideas anyway for the future and for knowledge sake!