Hi,

Try using

=MID(A1,1,FIND(",",A1)-1)&" "&MID(A1,FIND("
",A1)+1,(FIND("!",SUBSTITUTE(A1,",","!",2))-FIND(" ",A1)-1))

where the names are in A1. This would give the 'firstname last name'
format in one single cell.

Another alternative is to use SPACE as delimiter, but select the rest of
the names and choose 'DO NOT IMPORT' in the Text to columns window.

Regards

Govind.

NewKid wrote:
I am trying to split names across columns. The problem is that some names
spilt into 3 columns (first, middle, last), and others split across 5 or 6
(extra names, etc.)

Is there a way to specify split, using SPACE as a delimiter, but only split
on the first TWO spaces, then leave the rest alone?

I'm having a terrible time figuring this out. Any ideas anyone?

Thank you so much!

Mary