Parse out field

[MJOHNSON]

If you have first name and last name all in one field,
how do you parse it out to pull first name into its own
field and last name into its own field.


Field 1: Jane Sample
I want it to be Field 1: Jane
Field 2: Sample

Thanks!

 

[Iris Faber]

Read this Microsoft Article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;209045
If you have first name and last name all in one field,
how do you parse it out to pull first name into its own
field and last name into its own field.


Field 1: Jane Sample
I want it to be Field 1: Jane
Field 2: Sample

Thanks!