Grab digits to the right of the "-"

tgattsh

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...

Kelly Moore

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?

Kelly

Kelly Moore

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?

Kelly

tgattsh

@Kelly Moore You're Awesome!