Looking for specific text Value in cell

  • Thread starter Thread starter Dan Gesshel
  • Start date Start date
D

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
 
With your text in a1 try

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

Mike

which will
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
How to retrieve value from specific cell value? 1
find and scroll to cell string value in Excel 2
Move multiple values in single Cell To Cells of there own? 3
Convert text to values 6
Superscripting text in a cell 1
CountIf query for words within string 1
Import Hours as Text 1

Back
Top