Formula for separating names

Hello all i have a smart sheet that was imported from excel and need help. Currently I only have the full name in one cell (i.e) John doe. I want to have it where it will split the first and last name into the next two cells in the same row. And then I need it to take either the full name or the two separated names and create an email for it.

Example:

Column 1: full name: John Doe

Column 2: first name: John

Column 3: Last Name: Doe

Column 4: Email: John.doe@XYZ.com

and all of these are in the same row. I then need to take that email and have it fill a cell to a different smartsheet with other data on it but I usually use a vlookup with that. If there is a better way to do all of this with one or two formulas then please submit! :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!