Grab digits to the right of the "-"

I'm trying to separate the Area-Route column.

For Area I'm using =LEFT([Area-Route]@row, FIND("-", [Area-Route]@row) - 1) and this seems to work fine.

For the Route I'm using =RIGHT([Area-Route]@row, FIND("-", [Area-Route]@row) + 1) but this doesn't seem to work. You can see that their could be zero digits to the right of the "-" or several digits.

Any help would be appreciate! Thank you...


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Answer ✓

    Hey @tgattsh

    Try this

    =RIGHT([Area-Route]@row, LEN([Area-Route]@row) - FIND("-", [Area-Route]@row))

    The number of characters is determined from the difference between the length of the textstring and the hyphen.

    Does this work for you?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!