Using trim feature
 

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

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?


"Pat" wrote:

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