Formula to move text in order for first name first and last name last

[Chris McGlothen]

I have a list of names that I am trying to change the names around so they'll be in order, First name then last name, not last name and first name. Some of the names are a business and don't have a comma. For those I would like them to just say the business name.

In Column "B" is my list of names. I want Column "C" to show me the result. I can change the names around in the manner I want, the problem is I don't know how to make it do a name without a comma. It gives me an error when it finds a name without a comma. Again, for those I just want it to show me the name in the order it is shown. Thanks in advance,

Here is the formula I am using. I am sure there is something better.

Please Login or Register  to view this content.

[dosydos]

You could just add an Iferror() function to the beginning of the formula, like so:

=IFERROR(IF(B2="","",MID($B2,FIND(",",$B2)+1,256)&" "&LEFT(B2,(FIND(",",B2,1)-1))),B2)

If there is no " , " then it throws back the #VALUE!, so Iferror knows if there is an error then copy the current list as is.

[Chris McGlothen]

Thank you dosydos. This was exactly what I needed.

[dosydos]

glad to help. Thanks for the rep