Email changes to name when transferred
I have a formula in my spreadsheet to "join" several cells together. The individual cells are emails and they do no have more than one cell with data.
SOMETIMES, the email changes to a "First Last" name format when it reads it in the "Current Gate 2 Owner" cell, but not always and there is no pattern that we can tell. How do we keep it as an email address?? The column is set up as a contact list (email). The problem is that there are dynamic views and automation emails that do not recognize it when it converts to "First Last" name format. Any suggestions?