Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and report matching numbers in two worksheets | Excel Discussion (Misc queries) | |||
How do I insert page numbers on an Excel report. | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
can excel report scientific values rather than absolute numbers? | Excel Discussion (Misc queries) |