Skip to main content
Question

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

Forum|alt.badge.img+2

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"?

This topic has been closed for replies.

Forum|alt.badge.img+6

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

    Terms & ConditionsAccessibility statement