Thread: extracting characters at a specified limit to seperate cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
tevid tevid is offline
external usenet poster
  
Posts: 4
Default extracting characters at a specified limit to seperate cells

Dave O wrote:
Will this do it for you?
=MID(A1,1,75)
=MID(A1,76,75)
=MID(A1,151,75)
=MID(A1,226,75)

that definatively worked thanks :-) i think i can survive doing it that
way, maybe someone knows a way to macro this for all the cells?

Reply With QuoteReply With Quote