cleansing

Question

hi team. how to remove these characters and just filter out the numbers in this words. please help me. thanks in advance.

column 1     Column 2

12Â new         Â£2.50

8Â new           Â£5

45 Â new        Â£ 12.2

Â new 85        10Â£

output

column 1     Column 2

12                 2.50

8                   5

45                12.2

85                 10

rag329 · Answer

thank you so much @Qiu

Qiu · Answer

@rag329 
I replace the alphabet and speciall character with RegEx

I hope there is other better way.

0822-rag329.yxmd