Using trim feature

P

Pat

I want to trim info from the beginning and end of data

Example1:
2 Abutilon Kentish Belle 2 litre

return: Abutilon Kentish Belle

Example2:
2 Acer plat. Crimson King 10 litre 1/2 Stan

return: Acer plat. Crimson King

Example3:
2 Azalea mollis (copper) 4 litre

return: Azalea mollis (copper)

As you can see there will be different requirements for the same formula to
accout of.
Any help warmly welcomed.

Pat
 
D

Duke Carey

Each of your examples has a single digit and a space at the beginning. Is
that ALWAYS the case?

Each of your examples has the word 'litre' preceded by 1) a space, 2) a
number, and 3) another space. Is that ALWAYS the case? And you want to
eliminate the text starting with this sequence and going to the end of the
string, right?
 
Top