Hi guys, I have a bit of a problem I wonder if I can do this with a few clicks instead of this tedious manual method.
I have a column of data with first name, last name, separated by a comma. There are 5000 names to get through and right now I'm cutting the last name (after the comma) and then pasting to a new column. Basically I need the first name and last name to be in two columns rather than in the one column separated by a comma like this..
Is there a way for excel to do this automatically for me?
So for example i want:
[Fred,Bloggs] - in the one column, to be turned into [Fred][Bloggs] - in two separate columns.
Bookmarks