asked on

Excel Formula

Hi!
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

ASKER CERTIFIED SOLUTION

Yamaafg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jon Covalt

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Yamaafg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lisafamf

ASKER

Here is a sample, thanks...
sampledata.xlsx

Jon Covalt

So, I've put my formula in and used the auto-fill tool to pull it down to the other cells. You can see the result in the attached document.
sampledata.xlsx

Yamaafg

here is the formula and result.
C--Users-yamam-sampledata.xlsx

lisafamf

ASKER

Thanks, all of your solutions worked. Can I accept them individually and give you all, all the points, or do I have to accept as multiple? Thanks soooo much for saving me hours of work!