LEFT Formula

ginamt3

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

Courtney S.

I think using the FIND function inside your LEFT function would work.

FIND Function | Smartsheet Learning Center

This formula should find the starting position of the " - " portion of the Job Name: =FIND(" - ",[Job Name]@row)

So if you put that inside the left function, you should get the characters to the left of that.

=LEFT([Job Name]@row,(FIND(" - ",[Job Name]@row)-1))

Gillian C

Hi @ginamt3

try

=LEFT([Job Name]@row, FIND(" ", [Job Name]@row) - 1)

*Just make sure there is a space between the two quote marks

Courtney S.

I think using the FIND function inside your LEFT function would work.

FIND Function | Smartsheet Learning Center

This formula should find the starting position of the " - " portion of the Job Name: =FIND(" - ",[Job Name]@row)

So if you put that inside the left function, you should get the characters to the left of that.

=LEFT([Job Name]@row,(FIND(" - ",[Job Name]@row)-1))

ginamt3

It worked like a charm! thank you.