Thread: [Solved] VBA code for changing capital letters become lower
View Single Post
 
Old 04-18-2012, 04:16 AM
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 Jasa,

You can do it without a macro, using a wildcard Find/Replace, where:
Find = ([0-9])[Xx]([0-9])[Xx.]([0-9])[Xx.]([0-9])
Replace= \1x\2.\3.\4
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote