Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
How to use TRIM function | Excel Worksheet Functions | |||
Excel Installing feature | Excel Discussion (Misc queries) | |||
installing feature | Excel Discussion (Misc queries) | |||
comment indicators should feature lock or pw protect limiting acc. | Excel Worksheet Functions |