How to eliminate certain word from a cell in Excell 2010

Hi,

In Column B  I have a text that may or may not have "MCO" in it. What formula can I use in column A, that will say if B1 has MCO, then return airport, if not blank.

For example B1 has  Andrea Kane_Ticket Refund

                     B2 has Ange/Tara Beth_ORF MCO ORF

Thanks!
LadkissonAsked:
Who is Participating?
 
nutschConnect With a Mentor Commented:
This should do it:

=if(iserr(find("MCO",B1)),"","airport")
0
 
Pasha KravtsovSupport EngineerCommented:
=IF(B1="MCO","AIRPORT", " ")

Open in new window

0
 
LadkissonAuthor Commented:
Perfect! And so simple!!:)
0
 
nutschCommented:
Glad to help.

Thomas
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.