Change name from surname, first name to first name last name

[Lulu1000]

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

 

[Joe4]

Just subtract one from the length, i.e.
=MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)-1)

 

[Fluff]

How about

=Substitute(MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)),",","")

 

[Lulu1000]

Just subtract one from the length, i.e.
=MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)-1)

Knew it would be something simple thank you very much

 

[Rick Rothstein]

You need to subtract one from the length...

=MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)-1)

 

[Lulu1000]

How about

=Substitute(MID(B63&" "&B63,FIND(" ",B63)+1,LEN(B63)),",","")

Thank you

 

[Fluff]

Glad we could help & thanks for the feedback.