Hi Paul, thank you for your reply. And I'm so sorry, I made mistake of writing Excel.. The correct one is Word 2007.

Yeah! It's confusing, how to make the logic conditions about this problem. Huff. ~`~

First, I want to let you know (x) is multiplication. But, dot (.) is sum

My data is processed in Word. I'm using 2 macro:
First macro is for replacing some characters that are unwanted (record macro)
Second macro is for lowering capital (X) and changing (x) after first (x) to dot (.) (the one you gave me)
And this one is gonna be the third

Then, the data is processed in Excel. I'm using 1 macro:
This macro is for sum the multiplications, ex:
10.20.30x10/ --> the result is 30
235.458.101x25.20/ --> the result is 135
1120.1135x10/ --> the result is 20

So, numbers before (x) is counted by the sum of dot (.)+1 -->(first result)
Number/s after (x) is counted by the sum of numbers between (x) and slash (/) -->(second result)
The final result is multiplication of first and second result

There are 3 ways for possible numbers before (x)
2 numbers/+dot(.), ex: 01 or 45 etc
3 numbers/+dot(.), ex: 245 or 939 etc
4 numbers/+dot(.), ex: 1174 or 8364 etc

If we limit the use of summing numbers after (x). So, there are just 4 for each section, can we solve this problem?

Possible sum after (x)
For 2 numbers before (x) --> 1 sum
For 3 numbers before (x) --> 1 or 2 sum
For 4 numbers before (x) --> 1 or 2 or 3 sum


Thank you Paul
Regards,


Jasa

If I already added a slash (/) then by adding this macro there would be 2 slash (/), isn't it?
Can we use a macro to find and replace multiple slashes with a slash?


Thank you Paul