Hello.

I'd like to look for a specific character or value within a given cell
that is part of a larger string of data, but I'm having trouble for some
reason.

So for example, if the Cell Value = "Hello123" I want to evaluate if the
Text "3" exists within the cell.

Any help would be greatly appreciated.

Thanks.

Dan


*** Sent via Developersdex http://www.developersdex.com ***

With your text in a1 try

=IF(ISERROR(FIND("3",A1)),"Not There","There")

Mike

which will

"Dan Gesshel" wrote:


Hello.

I'd like to look for a specific character or value within a given cell
that is part of a larger string of data, but I'm having trouble for some
reason.

So for example, if the Cell Value = "Hello123" I want to evaluate if the
Text "3" exists within the cell.

Any help would be greatly appreciated.

Thanks.

Dan


*** Sent via Developersdex http://www.developersdex.com ***

Yes, I have tried that and it works well, but I have a whole string of
information I'll need to look for. It makes the formula obnoxiously
long, so I was going to go the VBA route instead...unless I'm setting up
something wrong in the formula.


*** Sent via Developersdex http://www.developersdex.com ***