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

Question

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

Left([Code],"-O") and Left([Code],";-O,") with both resulting in JKL

What is correct syntax to only strip "-O"?

DougHenning1 · Answer

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

Sign up