Forum Discussion

Qrew Cadet

7 months ago

Left function stripping on first "-" rather than "-O" as written

Using function Left in a formula to pull all text before a trailing "-O" If the Code has a "-" in the middle, it pulls back value prior to first "-" Code = JKL-6-O results in JKL I've tried Lef...

formulas

DougHenning1

Community Manager

NotRight("JKL-6-O", "-") will split at the last delimiter and returns "JKL-6"

SuzyKania

Qrew Cadet

7 months ago

Thanks so much. I thought I tried that but it left the second -. I was probably still using -O instead of focusing on the -. Appreciate the help.