View Single Post
  #1   Report Post  
lostgrave2001 lostgrave2001 is offline
Junior Member
 
Posts: 10
Question Copying out £ amount only

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