Thread: [Solved] Find and Replace
View Single Post
 
Old 07-14-2011, 08:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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