I'm using Google Sheets make a spreadsheet with the name in column a, the company in column b and in column f, I need their email.
I have 3 companies, and they have slightly different email formats. The first is firstname.secondname@compnayname.com, the second is the same, but the the third is firstname_secondname@companyname.com.
Is there a way I can format Google Sheets to fill in the emails for me with the addresses?
There are a few questions similar to this but they all have the names in first and second names separated, or are all in same email format?