Re: $$Excel-Macros$$ Splitting cell contents into multple rows

Thanks for replying sudhir, I understand your suggestion. But I was looking for a macro solution to it. Because sometimes the data may cross to thousands of rows and then it becomes very difficult to do it manually. Regards, Bikram --

$$Excel-Macros$$ Splitting cell contents into multple rows

Hello, Attached sheet contains data in column A where data in each cell is separated by ( | ). I want to separate out the data into multiple rows without overwriting. For example: Column A contains the data Row1:US20100081275A1 Row 2: CN101682937A_ | JP2010506381A_ | KR2009071614A_ | US2008008