Looking for specific text Value in cell

[Dan Gesshel]

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 ***

 

[Mike H]

With your text in a1 try

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

Mike

which will

 

[Dan G.]

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 ***