Breaking apart first and last names

[LyndieBee]

I know how to concatinate a first name field with a last name field, but how
do I take a list of names (i.e. JAMES SMITH) and break them apart into a
first name field and a last name field? Thanks for any suggestions.

 

[Alan Beban]

I know how to concatinate a first name field with a last name field, but how
do I take a list of names (i.e. JAMES SMITH) and break them apart into a
first name field and a last name field? Thanks for any suggestions.

Check out Data|Text to Columns

Alan Beban

 

[Frank Kabel]

Hi
use 'Data - Text to columns'