Thread: How to pop out individual data from cluster of data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GINN GINN is offline
external usenet poster
  
Posts: 3
Default How to pop out individual data from cluster of data
Cell A1 has 345-347,456;567,720
In column B, I would like to extract the above data as under:

B1 345
B2 346
B3 347
B4 456
B5 567
B6 720
Reply With QuoteReply With Quote