View Single Post
  #1   Report Post  
footballcmr2
 
Posts: n/a
Default How do I strip out some parts of a column of text data?

I have a column of text data, which happens to be 11 characters wide. I want
to strip the right-most 6 characters out of the entire column, without having
to do each cell one at a time. For example I want to to from this data: 2039
041175 to this data: 2039 for all 350 or so rows of data in the column on the
Excel sheet.