View Single Post
 
Old 09-21-2014, 02:46 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
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

You could also do it with just a wildcard Find/Replace, where:
Find = ([0-9]{2}/[0-9]{2}/[0-9]{2} Expense [0-9.]@ )([0-9.]@ )([0-9.]{1,})[!^13]@^13(*)^13(*)^13(*)^13*^13
Replace = \1(Billed $\2Reduced $\3) \4 \5 \6^p
No VBA required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote