Splitting a field

H

Heather

Hello

I need to split a field into two First and Last name.

FieldA
Smith, John

Need
First Last
John Smith
 
K

Ken Snell MVP

IF you always have a comma between the two name parts:

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