Pull all text that preceeds a /

[ahightower]

I need to pull all text and numbers that preceeds a "/" in a product ID. I can't use left or right because the / comes at different times. Does anyone have a formula for this?
Thanks!

[QATesterNY]

You can use the Instr function to find the position of the "/" character in the string. (This returns the first occurrence but I'm assuming your strings won't contain more than one instance of that character?)

Once you know the position you can use the Left function to extract the data.
RTTS - The Software Quality Experts www.rttsweb.com

[ahightower]

That worked Thanks!

[QATesterNY]

Great - you're welcome!RTTS - The Software Quality Expertswww.rttsweb.com