Quote:
Originally Posted by macropod
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
|
Hi, thanks a lot for helping me. Yeah, you are totally right and it can be done with Find and Replace. But, sometimes the data has 4 or more of "x".
Ex:
B3^t739X93.12.2.49.94 ---> 739x93.12.2.49.94
B4^t249.49.94x230x30x5x2165x5x5 ---> 249.49.94x230.30.5.2165.5.5
Would you mind to help? maybe it's better in macro
Thank u so much
Regards,
Jasa