I have a spreadsheet that has 4 columns -
Company Name, First Name, Last Name, Email Address
The first 3 are complete. the 4th, Email Addresses has blank cells.
Two issues: How do I create a valid email address for the blank cells using the information in the cell above? Also, is it...