How to convert the names to related emails

I have data in the main file and there are mixture of PM names and emails .I want to extract few of them from the list but the problem is since they are not same I mean mixture of email and Name not able to build a precise formula. Help in converting them to proper fromat before extraction.


  • KPH
    KPH ✭✭✭✭✭✭

    Are you able to share an example of what the column contains so we can understand the problem? If this is real people's data, can you use some fake names and emails and make a list that is similar? Then another list showing what you want to achieve.

    You might be able to utilize the FIND function to look for @ signs or something along those lines.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!