Thread: take some data column into next column ie ABC-DEF-GHI i want DEF
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default take some data column into next column ie ABC-DEF-GHI i want DEF
For a formula solution, use FIND within a MID formula. Or use a macro with
INSTR and INSTRREV

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bernard" wrote in message
...
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)

Reply With QuoteReply With Quote