I have text tile .. that is look like below

DATE|SCRIP CODE|DELIVERY QTY
02032010|511122|000000151
02032010|533022|000003935
02032010|526921|000007885

I want move this data in csv in columns and rows

where "|" symbol there will be column

How can i do this excel..

Thank you..