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!
PS, I'm using Excel 2013