Hi all,
I have a list of names that is surname, first name and want to change it to first name space surname without the comma.
I have this formula =MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)) which works to swap the name around but don't know how to remove the comma.
Currently like this Smith, Charles
With formula Charles Smith,
Want it Charles Smith
Is there something I can add to the formula to delete the comma please.
Thank you
I have a list of names that is surname, first name and want to change it to first name space surname without the comma.
I have this formula =MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)) which works to swap the name around but don't know how to remove the comma.
Currently like this Smith, Charles
With formula Charles Smith,
Want it Charles Smith
Is there something I can add to the formula to delete the comma please.
Thank you