Thread: extracting characters at a specified limit to seperate cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
  
Posts: 427
Default extracting characters at a specified limit to seperate cells
Will this do it for you?
=MID(A1,1,75)
=MID(A1,76,75)
=MID(A1,151,75)
=MID(A1,226,75)

Reply With QuoteReply With Quote