HairyHippy
Programmer
If I have a cell that has text in it, say a name like "Joe Bloggs", how do I tell Excel to find the space and then return everything to the right of the space? In this case the answer would be Bloggs but in "Charlie Brown", the answer would be Brown.
Thanks in advance!
Thanks in advance!