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:
4391.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:
739.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, Excel 2007
Any help would be great.
Regards
Jasa
Bookmarks