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
thank you so much @Qiu
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |