View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bobby
 
Posts: n/a
Default Split or cut a value reverse trunc()???

Hello,

I have a list of numbers in one column that look like this 06-6102-00-5969 I
want to write a formula in a separate column that will capture only the last
4 digits, 5969. I want to disregard, the first part of the number and only
save the last 4, possible?