Thread: take some data column into next column ie ABC-DEF-GHI i want DEF
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default take some data column into next column ie ABC-DEF-GHI i want DEF
one way:

=MID(A1,FIND("-",A1)+1,3)

On 10 Lis, 14:51, Bernard wrote:
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