Thank you both for your responses they both worked great. i know have a similar problem once cell has two amounts in the same cell is there any way i can put these in two to separate cells e2 and f2?
"betta £1200.00 40 /1234564 gamma £3000.00 "
Thank you again in advance.
CR
Quote:
Originally Posted by lostgrave2001
hello
i have the following text in cell A2
123456 batman £15000.00
i would like to be able to coy just the £ amounts in to cell D2.
could anyone please help me.
Kind regards
CR
|