AnsweredAssumed Answered

Trimming email text fields - more than white space needs to go

Question asked by on Jul 4, 2014
Latest reply on Jul 6, 2014 by erolst

Thanks in advance for any help.


I need to export a bunch of email addresses, then upload them to e-vite for an upcoming event.

When I do, I get unspecified errors at e-vite (and of course, no customer service.)


So, I THINK that the problem has to do with this little renegade characters I am seeing after the email addresses when I open them up in excel.


Apparently, the extra characters residing in my email text fields are not just while space.


Is there a way to create a loop to trim out all white space, and all characters except letters, a period (.) or an @ sign?