Hello everyone,
When I save a single-column list of words as CSV on Excel 2003...
banana apple orange mango
and open the file on Notepad, I get the following layout:
banana apple orange mango
But I wanted it to be...
banana,apple,orange,mango
I need to copy/paste the data as comma-delimited into a web application - and no matter how I open the CSV file it never shows as actually comma-delimited.
Would this require a VBA macro to export the data the way I want it to appear?
Thanks!
Last edited by mptorr; 12-29-2010 at 04:32 PM.
Hello mptorr,
In a CSV file, Excel separates each column using a comma. Each row is represented as a new line character. When Excel reads back the CSV, it restores the data the same way. If you have more than one column of data you will see the data separated by a comma in Notepad.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks Leith -- very helpful for me to decide what to do next.
I copied all cells > pasted special (with Transpose) > exported as CSV.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks