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
--
Hi Practice Practice,
Open the file in Excel. You will find all the information
autofit the data
Select all and then Use Text To Columns Feature in Excel.
Choose the Delimited option. And the the Next Screen you will have a place
to type a customized delimiter.
Type the Pipe symbol in that and clic
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
