Frustrated! I have 1 column, 320 rows of email addresses, but when exported from contacts into the .csv format, they all came out as this (examples only):
(row 1) [email][email protected]
(row 2) [email][email protected]
(row 3) [email][email protected]
...and so forth. Some have Auto-AddedEmail1, some have AutoAddedEmail1 (with or without the dash - ). Obviously, I want only the email address but I can't figure out how to parse the Auto-AddedEmail1 data. I'm uncertain how to trim (?) 15 OR 16 characters from the right, so I am left with only a valid email address. All I came up with is =trim(RIGHT(A1, [16]) I think I'm close, but not close enough!
Bookmarks