Thread: Deleting a consistant portion of all cells in a given column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Deleting a consistant portion of all cells in a given column
I need to remove only the first 10 characters of 40 character cells in a
given column.
What is the formula to produce this result? All cells are currently 40
characters in length.

=MID(A2,11,999)

Rick
Reply With QuoteReply With Quote