Thread: [Solved] Formatting
View Single Post
 
Old 03-26-2011, 10:10 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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 cegbuna,

Apologies - the Find/Replace expression I posted is for the reverse of what you're after. Try the following wildcard Find/Replace:
Find = ([!^13]{1,})^13
Replace = ^39\1^39,

After running this, you'll have an extra comma at the end of the data, which you can delete manually.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote