check if cell contains specific text

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

Microsoft Excel

Last Comment

Subodh Tiwari (Neeraj)

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Rgonzo1971

7/22/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Subodh Tiwari (Neeraj)

7/22/2016

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Ian Bell

7/22/2016

ASKER

Thanks guys, both work. Almost a dead heat again :)

Subodh Tiwari (Neeraj)

7/22/2016

You're welcome. Glad we could help. :)

I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst

Certified Expert Program

Credly Partnership

Udemy Partnership