View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Robert Crandal Robert Crandal is offline
external usenet poster
 
Posts: 309
Default formula to delete first n chars

I need a formula which will delete or remove the first N
(or leftmost N) characters from a text cell. I tried
looking at the left() and right() formulas, but they
KEEP the left or right data, rather than delete.

thanx