Save Excel File as # seperated file

[barnard89]

Hi

I am using Excel 2000
I need to save the Excel file on to another flat file
Usually I used to save as a .csv file

But now the data has embedded comma(",") in it.
So I am now changing the delimiter as #

How can save it as a # delimited file

For example if the Excel file has data like AAA, BBB, CCC
in columns A, B , C respectively they should be transported to the flat file like
AAA#BBB#CCC

How can I do it
Please suggest

thanks

 

[TonyJollans]

Hi barnard89,

You can still save as comma-separated - data conaining commas will be written out as quoted strings.

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[