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
Bookmarks