View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
billbrandi billbrandi is offline
external usenet poster
 
Posts: 26
Default Trimming/Truncating Text Field in Excel

I have a file with 3 text columns that I am using as a mailing list. I want
to remove the leading 5 characters from each text field and the trailing 10
characters from the same fields. How would I do this?