Forum Discussion

SuzyKania's avatar
Qrew Cadet
2 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...