Left, Right, Find, Formula Help!

KALESHIRE
KALESHIRE ✭✭
edited 07/30/24 in Formulas and Functions

I need help creating formulas to split cell information.

One cell contains indexed information in this string format:

FirstName LastName Email@Email 888-888-8888

I need the formula to split to each of these 3 columns

  1. FirstName LastName
  2. Email
  3. Phone

Thank you!

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!