We help IT Professionals succeed at work.
Get Started

Excel Formula

lisafamf asked
Last Modified: 2015-12-01
I have 20,000 cells with names in them. Some are individuals, some are families.   These are in column A.  In column B every cell is filled with the word individual.  I need to fill in B with the word family for any cell in column A that has "&" in it.  I am thinking I use an "if" formula, but I'm not sure how to get the results I need.  I'm not familiar with how to use "if" formulas.
Can anyone help me?  Is this possible?  Thanks in advance for your help!
Lisa :)
PS, I'm using Excel 2013
Watch Question
This problem has been solved!
Unlock 3 Answers and 7 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE