Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2011, 09:44 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 Find and Replace

How will i Find and insert a <space> after 9th anycharacter in Find and Replace Box.



Example1: (402) 551-394139 with (402) 551-3941 39 ;
Example2: (650) 589-678899 with (650) 589-6788 99

after the closing bracket i have a space followed by any 3 digits, a hyphen and I need a space after 4 digits
Reply With Quote
  #2  
Old 07-12-2011, 07:15 PM
macropod's Avatar
macropod macropod is offline Find and Replace Windows 7 64bit Find and Replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi kjxavier,

Try a wildcard Find/Replace, where:
Find = ([0-9]{3}-[0-9]{4})([0-9]{2})
replace = \1 \2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-12-2011, 10:38 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 Hello! Paul Edstein

Yup, That helped a lot.

thanx Mr. Paul Edstein
Reply With Quote
  #4  
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
  #5  
Old 07-14-2011, 08:09 PM
macropod's Avatar
macropod macropod is offline Find and Replace Windows 7 64bit Find and Replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi xavier,

Try a wildcard Find/Replace, where:
Find = ([! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])
Replace = \1 \2
However, if you've also got email addresses like 'paulgirard@optonline.net.au' merged with other text (eg 'paulgirard@optonline.net.auSYDNEY'), a separate wildcard Find/Replace operation will be required for them, where:
Find = ([! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3}.[a-zA-Z]{2})([!. ])
Replace = \1 \2
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 07-20-2011, 05:27 AM
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
Exclamation Hi! there...

it worked at one place ... but for some other lines it didn't.
Find[! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])
Replace with: \1 \2

For Example: ognjanovic@collegeclub.comA -changed to- ognjanovic@collegeclub.com A (perfect)

but not for these lines:
oni@optonline.netPortage
pollonais@collegeclub.comPALM
pappyjump@aol.com HoustonTX (where single space is already there)
orit.moalem@adttsa.com Petaluma
randall.e@aug.comGlen
otutmaz@aol.comElmhurst
Reply With Quote
  #7  
Old 07-20-2011, 05:38 AM
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 Sorry One more thing

When this stands alone it works
oni@optonline.netPortage
pollonais@collegeclub.comPALM
randall.e@aug.comGlen
otutmaz@aol.comElmhurst

but when something is there before the email i.e. spaces like this
Pi oni@optonline.netPortage
DP pollonais@collegeclub.comPALM
Caprice ct randall.e@aug.comGlen
22 kemville otutmaz@aol.comElmhurst
here it does not work...


pappyjump@aol.com HoustonTX (where single space is already there after "H")
orit.moalem@adttsa.com Petaluma (where single space is already there after "H")

Please correct me if am wrong somewhere.....
Reply With Quote
  #8  
Old 07-21-2011, 12:13 AM
macropod's Avatar
macropod macropod is offline Find and Replace Windows 7 64bit Find and Replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi xavier,

Try changing the Find expression by adding a '<' after the first '(', that is:
Find = (<[! \@]{1,}\@[!.]{1,}.[a-zA-Z]{3})([!. ])
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 08-10-2011, 10:07 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 Find and Replace...

Quote:
Originally Posted by macropod View Post
Hi kjxavier,

Try a wildcard Find/Replace, where:
Find = ([0-9]{3}-[0-9]{4})([0-9]{2})
replace = \1 \2
Hi!

I have many Email ID's converted from some software.
But for some ID's there are Case Problems

E.g.: RUBLE@MSN.COM this is OK(let the Capital Mail ID's contain Cap Extension)

But : becky@msn.COM this ID should be becky@msn.com
St.navygary3@aol.COM should be St.navygary3@aol.com

how can solve the Extension Case Problem using WildCard
Reply With Quote
  #10  
Old 08-11-2011, 04:47 AM
macropod's Avatar
macropod macropod is offline Find and Replace Windows 7 64bit Find and Replace Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi xavier,

You can solve this with a wildcard Find/Replace, where:
Find = (HYPERLINK "mailto:[!\@]{1,}\@[a-z]{1,}.)(COM)
Replace = \1com
and, before executing the Find/Replace you toggle the field code display 'on' via Alt-F9. Toggle it 'off' via Alt-F9 again afterwards.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
find and replace

Thread Tools
Display Modes


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 04:25 AM.


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