troubleshooting Question

Excel Formula

Avatar of lisafamf
lisafamfFlag for United States of America asked on
Microsoft Excel
7 Comments3 Solutions67 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 3 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros