Removing Non Printing characters...Not with Trim

Hi I am trying to clean up a list of email addresses. It has been imported into Excel and now has a bunch a spaces at the end...which ended up being non printing characters (weird A's), that didn't appear until you try and use the address. I have tried both the Trim and Clean function. Neither will work...Suggestions????

I can't actually diagnose your problem without seeing an example spreadsheet but...

Please Login or Register  to view this content.

That will look for a text string ".com" (four characters starting with a period) and only import everything to the left of the the string (inclusive, when we add that +4 to the second input to the LEFT formula).

Off the top of my head I can already think of problems you could have with this code; for example, Canadian emails end with .ca, not with .com, so if you have like "[email protected]" it will thrown an error rather than cleaving off your right-side garbage like you want.

If this doesn't fit your need I would prefer to see an example spreadsheet before doing more.