| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you remove some numbers in a series eg 1500024500 = 24500
Please help
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you remove some numbers in a series eg 1500024500 = 24500
Hi
If they are always the same length then =RIGHT(A1,5) This will return a Text value. If you want it as a numeric value then =--RIGHT(A1,5) -- Regards Roger Govier "BobDylanfreak" wrote in message ... Please help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do you remove some numbers in a series eg 1500024500 = 24500
"BobDylanfreak" wrote: Please help Thank you all i have solved the problem Cheers, BobDylanfreak |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Series of numbers | New Users to Excel | |||
| remove last character in a series of different length part #'s | Excel Discussion (Misc queries) | |||
| How to change a series of positive numbers to negative numbers | Excel Worksheet Functions | |||
| Can I remove Row Numbers? Or have the Row Numbers start on the Ro | Excel Discussion (Misc queries) | |||
| Remove Legend Series | Charts and Charting in Excel | |||
Linear Mode
