Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi, here is what I am trying to do.
In Cell A2 I have the number 90379614070 I want Cell B2 to take the last number in that cell, the 0 and paste it there I have 962 rows of numbers so you can see why i want a formula 2nd thing i want to do is after i have completed the first thing, i want a formula to remove that last 0 and the last number from every number in the A column. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Basic Excel formula | Excel Worksheet Functions | |||
Basic Future Value Formula & Interest Rate Formula | Excel Discussion (Misc queries) | |||
excel formula - possibly visual basic method | Excel Discussion (Misc queries) | |||
Excel formula similar to a loop in Basic? | Excel Worksheet Functions | |||
Formula in Visual Basic For Excel | Excel Discussion (Misc queries) |