Forum Discussion
Solved
How to put formatted text in one cell when another cell value is blank
How to put formatted text in one cell when another cell value is blank. In one column I have phone numbers. For the cells that don't have a phone number (G1), I want another cell in the next c...
You can test whether the phone number is present using
= IF(ISNUMBER(phone), "", "Record not clean")Using modern Excel, a more precise test might be
= IF(REGEXTEST(phone, "^\d{10}|\d{7}$"), "", "Record not clean")which requires 7 or 10 digit numbers.
Question is not clear enough. You may try IF() or MATCH() function. You may also need combination of few other functions. Post few sample data and show your expected output.