LEFT Formula

ginamt3
ginamt3 ✭✭✭✭
edited 04/12/24 in Formulas and Functions

I'm looking to capture the characters to the left of the space "-". Is there a way to do it so that when there are only 2 characters I need that it doesn't give me "MO -"

=LEFT([Job Name]@row, 4)

GSID - South Warren Ave PH1

MO - Haydinger Kitchen

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!