View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kable58 kable58 is offline
external usenet poster
 
Posts: 3
Default basic excel formula

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