View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Bernard is offline
external usenet poster
 
Posts: 30
Default take some data column into next column ie ABC-DEF-GHI i want DEF

i want to copy the mid section of the data in a column into the next column.
each row has a cell with this "ABC-DEF-GHI" configuration of date. i only
want "DEF" (the middle section)