I have an exported spreadsheet that has empty rows. I am applying the following formula to determine whether a cell contains an email address or postal address:
=IF(ISNUMBER(FIND("@",H5)),"E", "P")
Problem is I have blank rows and do no want the False value ("P") to show up in those rows. What is the fix?
Thanks!
Bookmarks