Left function


I have text like this

Devon Red 4.5% vol 11 Gallon 88 0.89 78.00

I want to cut left untiol the % symbol, so for the above i would return

Devon Red 4.5%

The amount of characters can vary however e.g

Vintage 7% vol 20L bib 36 1.13 40.80

What can i use to trim?

Who is Participating?
Rory ArchibaldConnect With a Mentor Commented:
should do it.
Seamus2626Author Commented:
Good man Rory
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.