Excel conversion to a tab dellimited file

Hello All! I have an Excel spreadsheet that is formatted for various users here in the finance department to use to post our journal entries. In order for me to get the entries into our accouting system, it has to be in a tab delimited format. I understand tab delimited formatting, with use of the comma's in Excel to make quotations in tab delimited, but I'd rather not have comma's on the formatted sheet that finance will be using. In addition, there are some cells on the formatted sheet that really don't need to be moved over to the accounting system in order to post them. Can anyone help me on how to remedy this?

This is the finance formatting in Excel:

JE # Posted: 5/31/2012
Approved:
Wedgewood Pharmacy
Journal Entry
Date: 5/31/2012

Date GL Code Description Debit Credit
05/31/12 4330-00 COS - RX/Compound 1392.35
4340-00 COS - Veterinary 5569.41
1216-00 Inventory-Finished Prep. 6961.76

Adjust Finished Goods Inventory to Month End Balances - May 2012


Totals - -

This is what needs to be done in order to import the journal entry....

"@HDR," "BATCH," "20120531," "Adjust Finished Goods Inventory to Month End Balances - May 2012," "@HDR," "JOURNAL," "JE," "4330-00," "COS - RX/Compound," "2012," "00005," "20120531," "JE," "GL," "Adjust Finished Goods Inventory to Month End Balances - May 2012," "USD," " 1392.35, " "1.00," "USD," " 1392.35, " "0.00000000," "D," "WED,"
"4340-00," "COS - Veterinary," "2012," "00005," "20120531," "JE," "GL," "Adjust Finished Goods Inventory to Month End Balances - May 2012," "USD," " 5569.41, " "1.00," "USD," " 5569.41, " "0.00000000," "D," "WED,"
"1216-00," "Inventory-Finished Prep.," "2012," "00005," "20120531," "JE," "GL," "Adjust Finished Goods Inventory to Month End Balances - May 2012," "USD," " 6961.76, " "1.00," "USD," " 6961.76, " "0.00000000," "D," "WED,"
"@END," "JOURNAL,"
"@END," "BATCH,"
I appreciate any input!

Thanks, Jill

TEXT(TAB DELIMITED) file format or COMMA SEPARATED VALUE?

Because you can take a worksheet "Save As" either (note: the current worksheet only, not the whole workbook).

Anyway, for either of them, the process is straightforward--you just Save As, no fuss, and then open with import wizard.

Originally Posted by OP

JE # Posted: 5/31/2012
Approved:
Wedgewood Pharmacy
Journal Entry
Date: 5/31/2012

Date GL Code Description Debit Credit
05/31/12 4330-00 COS - RX/Compound 1392.35
4340-00 COS - Veterinary 5569.41
1216-00 Inventory-Finished Prep. 6961.76

Adjust Finished Goods Inventory to Month End Balances - May 2012

I copypasta'd that into an excel, Saved As text (TS), opened the resulting txt with excel, breezed through the import wizard, and regenerated exactly what I'd started with after the copypasta.

I guess the thing is, without having an example spreadsheet to play with, I'm basically not seeing what your problem is.

Ok, I don't think I explained this very well but I can't attach my files on here for some reason. Anyhow, I have an Excel sheet set-up to be used. This sheet is just for back-up purposes for our journal entry binder. The only way for the journal entry information to get imported into our MAS500 accounting system is if the file is tab delimited. So, I'd need to get the Excel file into tab delimited which I know how to do through Save As, but the Excel file has things on it that aren't necessarily needed to enter into MAS500 through tab delimited. For instance, one of the fields that the entry must indicate is if the value is in "USD", but on my Excel sheet, I am not putting that info. In addition, the sequence of how the imported file needs to look goes @HDR, @BATCH, DATE, ect. So, it's almost as if my journal entry form has to be in the exact same way the tab file would look. That kind of stinks though because the tab delimited format is a bit odd. Do you know what I mean or are you still confused?