Solved

How to eliminate certain word from a cell in Excell 2010

Posted on 2014-03-27
4
115 Views
Last Modified: 2014-04-02
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!
0
Comment
Question by:Ladkisson
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 400 total points
ID: 39960159
This should do it:

=if(iserr(find("MCO",B1)),"","airport")
0
 
LVL 5

Expert Comment

by:Pasha Kravtsov
ID: 39960166
=IF(B1="MCO","AIRPORT", " ")

Open in new window

0
 

Author Comment

by:Ladkisson
ID: 39960167
Perfect! And so simple!!:)
0
 
LVL 39

Expert Comment

by:nutsch
ID: 39973797
Glad to help.

Thomas
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now