Thread: Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Puzzled Trainer Puzzled Trainer is offline
external usenet poster
 
Posts: 1
Default 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