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
