Hi All,

I have a spreadsheet with 4 columns which contain credit card information inc name, exp date, number etc. We sent this information to the bank as a text file. The bank need to see the information in the following format

"Garry Smith","1st Street", "5646898272626","07/07"

How do I get Excel to add the " " marks between each field?

If I save the xls as a txt file I get the following;

Garry Smith,1st Street, 57363749373830, ..........

Thanks
Garry