Convert the order the first and last name is written via formula

[polska2180]

Hi assuming I have

"Driver Name: Donald Williams Jr" in Cell A1 in B1 I am looking formula that will show "Williams Jr, Donald"

...not sure if that is possible so the other option is in B1 have just "Donald Williams Jr" then in C1 "Williams Jr, Donald"

thanks for the help.

 

[polska2180]

driving and looking at the forum I see many of you enjoy the challenge...ty for the help i will test out shortly

 

[polska2180]

Taking a different approach to the combined formula, this one looks like it works.

=SUBSTITUTE(MID(A1&", "&A1,FIND(" ",A1,14)+1,LEN(A1)+1),"Driver Name: ","")

This one worked all the way up to where I found a few records saying: Driver Name: None

 

[polska2180]

You guys are awesome, multiple suggestions worked...ty.

for my none issue above i will just put an if statement that will be an easy fix.

 

[jasonb75]

This one worked all the way up to where I found a few records saying: Driver Name: None

Depends what you want to see when that happens.

=SUBSTITUTE(MID(A1&", "&A1,IFERROR(FIND(" ",A1,14)+1,1),LEN(A1)+1),"Driver Name: ","")

or

=IFERROR(=SUBSTITUTE(MID(A1&", "&A1,FIND(" ",A1,14)+1,LEN(A1)+1),"Driver Name: ",""),"")

are just 2 ways of dealing with it.

 

[DanteAmor]

You guys are awesome, multiple suggestions worked...ty.

Im glad to help you. Thanks for the feedback.