AnsweredAssumed Answered

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

Question asked by slayden@msn.com 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?

 

Scott

Outcomes