Report Numbers only

T

The Rook

A1 = 200C, I would like B1 to show the content of A1 with out the the letter
at the end. ie 200. I have tried to use INT, but that will only work on
decimal numbers.

Thanks
 
T

The Rook

Thanks for that, but I should have also mentioned that the number could vary
in length ie 1C or 10C or 100C or even 1000C Therefore +left doesn't work

Thanks
 
T

Teethless mama

Try this:

=--SUBSTITUTE(UPPER(A1),"C","")


The Rook said:
Thanks for that, but I should have also mentioned that the number could vary
in length ie 1C or 10C or 100C or even 1000C Therefore +left doesn't work

Thanks
Click to expand...
 
R

Ron Rosenfeld

Thanks for that, but I should have also mentioned that the number could vary
in length ie 1C or 10C or 100C or even 1000C Therefore +left doesn't work

Thanks
Click to expand...


Then use:

=--left(a1,len(a1)-1)

--ron
 
Top