Posted: 7/23/2009 1:36:58 PM EDT
|
Does anyone here know how to create an ASCII file?
I have some data that needs to be in the following format; "first name", "last name", "address", "city", "state", "zip code", Can anyone show me how to export from Excel into the above format? Thanks in advance. |
|
If you need the quotes around the fields you could put them in in a different tab.
So, if A1 in your data tab has the value: first name then this formula in another section of the book: =CHAR(34)&A1&CHAR(34) would return "first name" Then you could choose file->save as with a .csv type to get a text file in the format you're looking for. |
|
Quoted:
If you need the quotes around the fields you could put them in in a different tab. So, if A1 in your data tab has the value: first name then this formula in another section of the book: =CHAR(34)&A1&CHAR(34) would return "first name" Then you could choose file->save as with a .csv type to get a text file in the format you're looking for. Cool. Thanks. I knew CSV was the way to go but just saving as csv wasn't getting the quotes. |