Left function

Hi,

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?

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
=LEFT(A1&"%",find("%",A1))
should do it.
0
 
Seamus2626Author Commented:
Good man Rory
0
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.