RE: $$Excel-Macros$$ Want to convert on Text in each cell to rows

2010-07-09 Thread Dave Bonallack
Hi Prashant, Please give an example of the converted cells Regards - Dave. > Date: Fri, 9 Jul 2010 18:06:07 +0530 > Subject: $$Excel-Macros$$ Want to convert on Text in each cell to rows > From: prashant...@gmail.com > To: excel-macros@googlegroups.com > > Hi all > I wa

$$Excel-Macros$$ Want to convert on Text in each cell to rows

2010-07-09 Thread Prashant Pednekar
Hi all I want to convert on Text in each cell to rows ? In each Cell has 50 + numbers one below one. e.g. 09:51:18 09:51:31 09:52:04 There are five such columns. Can any one help me to convert to rows? Regards. prashant -- -