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.
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.
The 1st function worked. The 2nd one resulted in #NAME?. Not sure why.
I'll be using the 1st one from here on out.
Thanks
I'll be using the 1st one from here on out.
Thanks
That's not your fault. The regular expression functions are currently being rolled out (insider beta channel) so it is unlikely that you will have them yet. My apologies for that.
- Ok. Thanks again! Enjoy the weekend.