View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anne Anne is offline
external usenet poster
 
Posts: 74
Default Truncating text field in column

I have a text field in an Excel spreadsheet with (for instance) 10
characters. I wish to truncate the first 5 characters and leave the rest. Is
there an easy way to do that in Excel?