adding cells which include numbers and text
 

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 ;)

adding cells which include numbers and text
 

Hi!

One way:

=101-SUBSTITUTE(A5,RIGHT(A5,2),"")*1

Biff

"Shelley" wrote in message
oups.com...
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 ;)

adding cells which include numbers and text
 

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 ;)

adding cells which include numbers and text
 

Hi!

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

???

Biff

"Shelley" wrote in message
ups.com...
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 ;)

adding cells which include numbers and text
 

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 ;)

adding cells which include numbers and text
 

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 ;)

adding cells which include numbers and text
 

Ok, glad you got it straightened out!

Biff

"Shelley" wrote in message
ups.com...
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 ;)