help on adding numbers

[mavs]

hi, i am an idiot on excel but i'm trying to learn

i have a question, my datas to be inputted in each cells are a combination of text & numbers (although they will be separated by space), is it still possible to add just the numbers in another cell? pls advise.

btw, i just knew how to add numbers from one cell to another...but my problem is what if i plan to add the whole cells of the column? its to tedious to click on each cell. is there a shortcut for this? pls help too.

thanks!

[HiArt]

Hi Mavs,

I don't think you can do this easily. One option is to split the numbers in to a seprate column and SUM this. You could hide this column if you dont want people to see it and still put the result of the SUM at the bottom of the original data column.

To extract the number bit try
=VALUE(MID(D1,FIND(" ",D1)+1,999))

assuming D1 contains a bit of data in the format "abc 123".

HTH

Art