Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
I have a column of numbers (approximately 100 rows) and wish to remove the
last 2 digits of each one that ends with 01. Is there a way of doing this please? Example: 8015601 8025822 8036501 And so on Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Assuming numbers are in column A for this example, put this formula in an
available cell on same row and extend down the sheet. Row 1 used as example. This will work even tho it looks a little odd: =IF(RIGHT(A1,2)="01",INT(A1/100),A1) "Puzzled Trainer" wrote: I have a column of numbers (approximately 100 rows) and wish to remove the last 2 digits of each one that ends with 01. Is there a way of doing this please? Example: 8015601 8025822 8036501 And so on Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
try this:
=IF(RIGHT(A1,2)="01",LEFT(A1,LEN(A1)-2),A1) "Puzzled Trainer" wrote: I have a column of numbers (approximately 100 rows) and wish to remove the last 2 digits of each one that ends with 01. Is there a way of doing this please? Example: 8015601 8025822 8036501 And so on Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel
Either will accomplish the task, with on subtle difference:
the solution I offered leaves the new value as a number, the alternative solution coerces the solution into a number displayed as text. Pick whichever meets your needs? "Nikki" wrote: try this: =IF(RIGHT(A1,2)="01",LEFT(A1,LEN(A1)-2),A1) "Puzzled Trainer" wrote: I have a column of numbers (approximately 100 rows) and wish to remove the last 2 digits of each one that ends with 01. Is there a way of doing this please? Example: 8015601 8025822 8036501 And so on Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |