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

Options

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.


Answers

  • Paul H
    Paul H ✭✭✭✭✭✭
    Options

    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
    CLBai ✭✭✭
    Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!