Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

check if cell contains specific text

Posted on 2016-07-22
4
52 Views
Last Modified: 2016-07-22
Hi,
I would like a formula that would determine if a cell contains specific text,
example
cell A2 contains     Babyface (NR)
If the cell contains (NR) as part of the text I want to return blank cell in B2
Help much appreciated as always
Many thanks
Ian
0
Comment
Question by:racepro
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
Rgonzo1971 earned 250 total points
ID: 41724463
Hi,

pls try
=IF(ISERROR(FIND("(NR)",A2)),A2,"")

Open in new window

Regards
0
 
LVL 30

Assisted Solution

by:Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj) earned 250 total points
ID: 41724466
Or use simply this....

=IF(COUNTIF(A2,"*(NR)*"),"",A2)

Open in new window

0
 

Author Comment

by:racepro
ID: 41724476
Thanks guys,  both work. Almost a dead heat again :)
0
 
LVL 30

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41724483
You're welcome. Glad we could help. :)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
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 …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

791 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