Report Numbers only
 

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

Report Numbers only
 

=Left(A1,3)

HARDEEP KANWAR

"The Rook" wrote:

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

Report Numbers only
 

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

"Hardeep_kanwar" wrote:

=Left(A1,3)

HARDEEP KANWAR

"The Rook" wrote:

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

Report Numbers only
 

Try this:

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


"The Rook" wrote:

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

"Hardeep_kanwar" wrote:

=Left(A1,3)

HARDEEP KANWAR

"The Rook" wrote:

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

Report Numbers only
 

On Wed, 27 Aug 2008 09:25:01 -0700, The Rook
wrote:

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

"Hardeep_kanwar" wrote:

=Left(A1,3)

HARDEEP KANWAR

"The Rook" wrote:

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


Then use:

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

--ron