LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Pat
 
Posts: n/a
Default 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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
How to use TRIM function Sky Warren Excel Worksheet Functions 3 January 8th 05 05:06 PM
Excel Installing feature Ams Excel Discussion (Misc queries) 1 December 30th 04 09:29 PM
installing feature Villa Bithiah Excel Discussion (Misc queries) 1 December 7th 04 07:21 AM
comment indicators should feature lock or pw protect limiting acc. summer_rose Excel Worksheet Functions 1 December 3rd 04 07:02 AM


All times are GMT +1. The time now is 11:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"