Thank you for this. However when i do sum it seems to exclude the whole cell
not just the letter!

"Sandy Mann" wrote:

Just SUM() them, SUM() ignores text.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Be18" wrote in message
...
I have to put text into several cells along with numbers, mainly astericks
and some letters, but I also want to sum these cells. How do i sum the
numbers and exclude the text? Please help!!