Read the excel help for Import or Export text files.
There is a bit in there called "change the delimiter".
You do it through the regional options on the start menu.
HTH
--
Allllen


"Vinod. Kulkarni." wrote:

HOW TO SAVE MY ACTIVE WORK SHEET AS TEXT FILE USING SEMICOLAN