Breaking apart first and last names
 

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.

LyndieBee wrote:
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

Hi
use 'Data - Text to columns'

--
Regards
Frank Kabel
Frankfurt, Germany

"LyndieBee" schrieb im
Newsbeitrag ...
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.