Someone has sent me a list of names (more than 90) which are typed into one cell, ie Fred Bloggs all in one cell. All the names are sorted by first name, ie Fred, not Bloggs, Fred, as I want them to be.
I know you can merge two cells into one to make them sort alphabetically but pretty sure I can't do anything with this other than retype the whole lot in surname, followed by first name...
Any ideas anyone??? Your help would be GREATLY appreciated.
Many thanks
I know you can merge two cells into one to make them sort alphabetically but pretty sure I can't do anything with this other than retype the whole lot in surname, followed by first name...
Any ideas anyone??? Your help would be GREATLY appreciated.
Many thanks