View Single Post
 
Old 04-18-2012, 01:33 AM
Jasa P Jasa P is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2012
Posts: 13
Jasa P is on a distinguished road
Default VBA code for changing capital letters become lower

Hi, I have some problems here. I have to change
1. the capital letter of "X" becomes lower letter "x" and
2. the "x" after first "x" becomes dot "."
Would you mind to help me?

For the example:
A2^t4391.4586X5.5.5/57x20/885.85x10/61x12/64.58x8/8328.2883x2x2x5/64.11.47x5/230.30.249.49x30/130.630.30.93.57.230x5

As you see the red one should be 4391.4586x5.5.5 and 8328.2883x2.2.5

For another example:
B37^t739.93.12x2/39.99x3/89.98x12/249.49.94.230.30x5/2989.8929X3X3X3/128x2.3/46x2/2165x5.5.5/0131.131.113.031.013x10/3

As you see the red one should be 2989.8929x3.3.3

I'm using Windows7 for notebook and XP for PC, Word 2007
Any help would be great.





Regards


Jasa
Reply With Quote