How do I extract first and last name from an email address in proper form?

CLBai

Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying to do.

Paul H

Try This

User Name =LEFT(Email@row, FIND("@", Email@row, 1) - 1)

First Name =UPPER(LEFT([User Name]@row, 1)) + MID([User Name]@row, 2, FIND(".", [User Name]@row, 2) - 2)

Last Name =UPPER(MID([User Name]@row, FIND(".", [User Name]@row, 1) + 1, 1)) + RIGHT([User Name]@row, LEN([User Name]@row) - FIND(".", [User Name]@row, 1) - 1)

CLBai

You are a lifesaver, Paul! It worked perfectly. Thank you!

PeggyLang

@Paul Newcome
How would you configure the above formulas to go from 'Email Address' to 'First Name' and 'Last Name'

I've got the 'First Name' formula

Stuck isolating the Last Name and capitalizing the first letter.

Paul Newcome

You would use similar logic in a MID function based on a FIND function. The starting point is right after the "." and the ending point is right before the "@".

=UPPER(MID([CBRE Email]@row, FIND(".", [CBRE Email]@row) + 1, 1)) + MID([CBRE Email]@row, FIND(".", [CBRE Email]@row) + 2, FIND("@", [CBRE Email]@row) - (FIND(".", [CBRE Email]@row) + 2))