How do I extract the left most word in a Column?

edited 09/14/21 in Using Smartsheet
09/14/21 Edited 09/14/21
Accepted

I'm looking for a formula to extract the left-most word form a column that will have different character lengths.


Looking at the example below:

  • Sometimes there is a / in front of that left-most word
  • Sometimes its just a single word
  • Sometimes there is a < in front of the left-most word



Thank you!

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Try something like this...

    =IF(FIND("<", [Parent Trailing]@row)> 0, LEFT([Parent Trailing]@row, FIND("<", [Parent Trailing]@row) - 1), IF(FIND("/", [PArent Trailing]@row)> 0, LEFT([Parent Trailing]@row, FIND("/", [Parent Trailing]@row) - 1), [Parent Trailing]@row))

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    Try something like this...

    =IF(FIND("<", [Parent Trailing]@row)> 0, LEFT([Parent Trailing]@row, FIND("<", [Parent Trailing]@row) - 1), IF(FIND("/", [PArent Trailing]@row)> 0, LEFT([Parent Trailing]@row, FIND("/", [Parent Trailing]@row) - 1), [Parent Trailing]@row))

    thinkspi.com

  • As always, you saved me hours of frustration! Thank you Paul.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

  • edited 09/17/21

    Hey @Paul Newcome - How would I tweak the formula to now pull the word after the / ?



    I've tried tweaking the "<" symbols or the "-1" but havent had luck. In the screenshot below I'm either trying to pull the word "Plan", "Execute" or "Closing".



    Thank you!

Sign In or Register to comment.