split last name first name

[Stephen S]

I have been sent a file with last name and first name in a single field. How do I separate them into 2 fields

Edited October 19, 2005 by Guest

[Kent Searight]

Use:

LeftWords ( text ; 1 )

for the part of the name that appears first

Use:

RightWords( text ; 1 )

for the part of the name that appears last

[Lee Smith]

Right and Left Functions will work if there aren't any "Mac, Van, Mc.", etc. in the list. There is a file that may be helpful attached to this thread. Click Here to Go However, I suspect that there could be a Custom Function or Calculation that can now do this.

HTH

Lee

[Stephen S]

NamePars is Very cool - thanks so much