Hello,
I've seen different variations of this on the forum but when I try to use what has been suggested it won't work. I need a formula that will return the number 1 if a cell contains a specific text. The cells would contain:
Smith, AB1
or
Doe, AB1
I need it to look for "AB1"
Thanks again for everyone's help.
try
=IF(ISERROR(FIND("ab1",A1)),"",1)
and copy down the rows
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That's one of the variations that I tried already, I keep getting the message that says the formula contains an error and it highlights "AB1",A1.
can you upload/attach a sample spreadsheet here
are you sure you are typing exactly as shown ?
You can use etaf's formula but you need to replace function FIND with SEARCH. FIND does the same thing as SEARCH but FIND is case sensitive and search is not.
=IF(ISERROR(SEARCH("ab1",A1)),"",1)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
may be like it
=IFERROR(FIND("AB1",A3)^0,"")
copy down
thanks for the correction AlKey
I just realized why it wasn't working, I had changed my deliminator to a pipe yesterday morning and forgot to change it back. I was still using a different formula than what you all posted so thank you for your help.
Here's another one...
=IF(COUNTIF(A1,"*AB1*"),1,"")
Case is not a condition.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks