View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George P George P is offline
external usenet poster
 
Posts: 9
Default remove unwanted text after the 7th position

I have a range of cells, all consistent with the first 7 positions. I want
to remove everything to the right of the 7th position. I've tried various
special characters in 'edit/replace' to no avail.

thanks for your help!