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 column (H1) to automatically put the text “Record Not Clean”?
How do I do this? Is there a certain function that allows me to do this?
Thanks
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 column (H1) to automatically put the text “Record Not Clean”? How do I do this? Is there a certain function that allows me to do this? Thanks Read More