Posted to microsoft.public.excel.programming

Extropian

external usenet poster

Posts: 3

Help with Find function

Hello,

I really need some help here. I am trying to find a "(" within a text string
in a column, but I get a #VALUE! error when I use it.

=FIND("(",A2,1)

How can I find the ( if it thinks it's part of the formula boundries? Please
tell me there's a way around this.

Thanks in advance!
Heather

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	Denver	Excel Worksheet Functions	3	July 9th 09 12:05 PM
Find Function	Jeff Gross	Excel Worksheet Functions	4	July 31st 08 05:34 PM
.find =< function	mark kubicki	Excel Programming	5	August 8th 05 09:36 PM
Find Function	Steve	Excel Worksheet Functions	2	May 11th 05 07:56 PM
backwards find function to find character in a string of text	Ashleigh K.	Excel Programming	1	January 14th 04 04:36 PM

All times are GMT +1. The time now is 04:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us