This may work. Assuming your data is in cell C1:C100 (change the range
reference as needed):

=SUM(VALUE(MID(C1:C100,SEARCH(CHAR(163),C1:C100,1) +1,SEARCH("m",C1:C100,1)-SEARCH(CHAR(163),C1:C100,1)-1)))

entered with Control+Shift+Enter

"tony" wrote:

Hi
I have a worksheet with column c recording values in the format of £1.5m ,
£2m etc but I need to sum this row is this possible ? or easy to convert ?
Thanks in advance Tony