Posted to microsoft.public.excel.worksheet.functions

Jeff Gross Jeff Gross is offline

external usenet poster

Posts: 64

Find Function

I am using the following formula to search for a "<" in a cell and then trip
off all text after it is found:

=IF(FIND("<",C11,1)-1,(TRIM(LEFT(C11,FIND("<",C11,1)-1))),C11)

My intention is that if there is no "<", then just return what is in the
cell originally.

It trim part works but if there is no "<" in the cell, then I get a #Value
error.

Any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Find Function	[email protected]	Excel Worksheet Functions	2	September 14th 07 08:26 PM
Need to find a function.	MikeCampbell	Excel Worksheet Functions	2	January 29th 07 01:40 AM
#VALUE about function Find	hui	Excel Worksheet Functions	14	September 12th 06 04:01 PM
Find function	alamo	Excel Worksheet Functions	1	September 16th 05 02:01 PM
Help with the FIND function	Ranger	Excel Worksheet Functions	1	February 25th 05 03:24 PM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us