Re: [MSAccessProfessionals] Split full name into first and last fields

Allen's code might be a bit of overkill but it offers much greater flexibility for future requirements.

Regards,

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of Doyce Winberry <doyce.winberry@xpo.com>
Sent: Wednesday, June 3, 2020 3:54 PM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] Split full name into first and last fields

 

Art,

Look at this link from Allen Browne. I think it will get you what you want.

Doyce

http://allenbrowne.com/func-10.html

From Art:

I have a field called TenantName and it contains the full name of the tenant in this format: Doe, Jane

I need to split the first  name and the last name into separate fields called FirstName and LastName.

Any ideas?

Thank you,

Art Lorenzini