Thread: Extracting multiple entries in a cell into their component pieces
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Extracting multiple entries in a cell into their component pie

N3:DD115 has 95 columns. Does your biggest cell have 95 entries?
Assuming it has and the output range DE22:DE78 contains zeros,
(I assume DE22:D278 is a typo) then the output is correct.
You have to copy down 95 times till the next entry shows.

Reply With QuoteReply With Quote