Text Strings

K

Ken

Hi, I have a field that looks like this:

LastName, FirstName

I want to strip out the text up to but not including the comma and put
LastName and FirstName is separate fields. I'd appreciate any help on this.

Thanks in advance and have a great weekend.
 
D

Douglas J. Steele

Assuming your existing field is FullName, you can calculate:

LastName: Trim(Left([FullName], InStr([FullName], ",") - 1))
FirstName: Trim(Mid([FullName], InStr([FullName, ",") + 1))
 
Top