Excel Formula

I have a column with various names on column A1. I want to put a formula on column B1 that looks at column A1 and if A1 has the words "Dorm" return the value "Dorm" else leave blank. Below is an example of what is con column A1 and A2. Do you have an Excel formula that can do this?

8858T17 - 2017
8858DORM
ConernestoAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,
pls try
=IF(ISERROR(FIND("DORM",A1)),"","DORM")

Open in new window

or case insensitive
=IF(ISERROR(SEARCH("DORM",A1)),"","DORM")

Open in new window

Regards
0
 
ConernestoAuthor Commented:
Thank you very much.

Conernesto
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
You may also try something like this...

=IF(COUNTIF(A1,"*DORM*"),"DORM","")

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.