adding cells which include numbers and text

S

Shelley

Hi, I am hugely ignorant regarding excel, no training, and apparrently
no brain... What I need to do is allocate a number to a placing i.e.
1st = 100, 2nd = 99, 3rd = 98 etc. If A5 (for example) has 1st in it, I
put in A6: =101-A5, but it will not add it because of the text. How do
I get the formula to ignore the text in A5???

Shelley ;)
 
S

Shelley

Hi Biff,

Thanks! Works the answer out great, but merges two cells together
where the answer is (using my example, it merged A6 and A7) - what am I
doing wrong?? :(

Shelley ;)
 
B

Biff

Hi!

Not sure I understand what you mean by: "merges two cells together where the
answer is".

???

Biff
 
S

Shelley

Hi again Biff,

I clicked on the merge & centre button and it re-split the cells, then
when I copied the cell containing the formula, it didn't merge any
more...
Thanks again for your help!

Shelley ;)
 
S

Shelley

Hi,

I posted my last comment before I saw your one - When I copied your
formula into A6, it calculated the answer correctly, but merged that
cell with A7. Does that make more sense? Anyway, I don't know how I
got it to do that, but it's OK now (see last reply).

Shelley ;)
 
Top