ASAP Utilities, a free add-in available at www.asap-utilities.com has a
feature that will strip out all of the alpha-characters......leaving just
the numerical ones to do your math with.

hth
Vaya con Dios,
Chuck, CABGx3


"Simon Lloyd"
wrote in message
...

Hi all, is it possible to sum cells that have both letters and figures
in?, i have lists of figures some of which look like this £3.5m, £5m
etc is it possible to write a formula which just sums the figures?

All help or suggestions appreciated.

Regards,
Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=571172