View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ArcticWolf ArcticWolf is offline
external usenet poster
 
Posts: 70
Default Keep last 4 characters of value

Hi,

I need to remove the last 4 characters of value (b1).
I also need to remove all preceeding characters except the last 4 characters
of a value (c1)
Each value is of a different lenght.

IE

a1= 1234567890 (original value)
b1=123456
c1=7890

Thanks in advance,

AW