Thread: [Solved] Find and Replace
View Single Post
 
Old 07-14-2011, 07:08 PM
kjxavier kjxavier is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Jul 2011
Posts: 39
kjxavier is on a distinguished road
Default Thanks a lot.... xavier

Dat helped me....

Can i have "DOUBLE SPACE" after the .com , .org , .biz or any three characters after the DOT of any E-mail Address.
So that i can Replace my Double Spaces to Tab Character and take it to another field in my XL sheet.

Example1: rawls@msn.comSAN DIEGO to rawls@msn.com SAN DIEGO
Example2: paulgirard@optonline.netsanta rosa to
paulgirard@optonline.net santa rosa


I just need 2 spaces after any three Characters after the DOT in only email address fields. (there are many dots in the line other than email) somethng like @ followed by a DOT(.)



xavier
Reply With Quote