Report Numbers only

[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

 

[Hardeep_kanwar]

=Left(A1,3)

HARDEEP KANWAR

 

[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

 

[Teethless mama]

Try this:

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

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

 

[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

Then use:

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

--ron