Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2011, 07:08 PM
kjxavier kjxavier is offline Find and Replace Windows XP Find and Replace Office 2007
Advanced Beginner
Find and Replace
 
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
Reply

Tags
find and replace



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and Replace Help with find and replace or query and replace shabbaranks Excel 4 03-19-2011 08:38 AM
find and replace anil3b2 Word 0 08-03-2010 11:30 PM
help with find and replace sjkiss Word 1 04-12-2010 08:08 AM
find and replace graphics thegeester Drawing and Graphics 0 04-04-2010 04:36 AM
Find /Replace Help ilcaa Word 2 11-02-2009 08:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft