View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lance Hoffmeyer Lance Hoffmeyer is offline
external usenet poster
 
Posts: 9
Default Stripping out contents of a cell after 8 characters?

Is there a way to strip out the contents of a cell after 8 characters?

The cell may have the following contents:
Q22_2 N22 The only supplement I ever take is a multivitamin
and I want to reduce it down to:
Q22_2

I am going to modify this as a loop to include a range of cells


Lance