More help please with contact list....

Originally Posted by Maistrye

This is useful, but you never indicated whether or not what MDubbelboer suggested was possible, such as the following:

John A. & Jane A. Van Doe, where Van Doe is the last name.

assuming last names never have a space in them we can return the string to the right of the last space as the last name, and follow with the first name with this monstrosity courtesy of scott:
=RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))&", "&LEFT(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

No names are separate currently but it is a possibility in the future. This last sum is not working for me.

Nevermind, it works great. Thanks for all your help everyone!

Originally Posted by ckluge

Nevermind, it works great. Thanks for all your help everyone!

Hi ckluge,

Never give up, there is always an answer

Your examples in A1:A3

John A. & Jane A. Doe
John & Jane Doe
John A. Jr. & Jane Doe

In B1 put this as an array formula, copy it, but enter it as Ctrl Shift Enter

=RIGHT(A1,LEN(A1)-MAX(ROW(INDIRECT("1:"&LEN(A1))) *(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)=" ")))

Then in C1, put this, but not as an array

=B1&", "&LEFT(A1,LEN(A1)-LEN(B1))

Result

Doe, John A. & Jane A.
Doe, John & Jane
Doe, John A. Jr. & Jane

oldchippy

Oldchippy,

You are a Saint ... !!!

Cheers
Carim