Posted to microsoft.public.excel.misc

Saxman[_2_] Saxman[_2_] is offline

external usenet poster

Posts: 33

Trim, Replace?

On 01/08/2007 21:46:04, Stephanie wrote:
=SUBSTITUTE(UPPER(TRIM(LEFT(A2,MIN(FIND({0,1,2,3,4 ,5,6,7,8,9,"("},A2&"0123456789("))-1))),"'","")

This works fine! I was thinking of having a 'helper' column to gid rid of the
apostrophies and then cleaning up, as in a previous post, but this is much
tidier.

Thanks a million!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Using =TRIM()	Chuda	Excel Worksheet Functions	6	November 9th 06 03:05 PM
Trim	Steved	Excel Worksheet Functions	7	August 1st 06 05:43 AM
Trim	stapleton2308	Excel Discussion (Misc queries)	4	February 15th 06 06:09 PM
Trim help please	Dave	New Users to Excel	8	September 1st 05 07:18 PM
trim	ferdy	New Users to Excel	4	May 11th 05 11:10 AM

All times are GMT +1. The time now is 03:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us