I have saved an excel spreadsheet as a CSV file and done the 1,000 space delimiter, but the place i need to upload this data too requires all fields to have double quotes (") either side of the info in the cell. How do i add this?
2007-12-26 20:57:16 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
lets say your data is in A1
then in B1 input "
then in C1 use the formula
=CONCATENATE(B1,A1,B1)
copy B and C all the way down.
then just copy column C, and paste values... to get rid of the formulas.
2007-12-27 19:13:02 · answer #1 · answered by expletive_xom 7 · 0⤊ 0⤋
I am not sure what is your purpose, however I am giving you a good way to work on CSV file. You can use Excel file to import and export what is related to CVS file or having delimiter characters.
Please follow steps
1) Open Excel
2) Go to the menu "Data\Import External Data\Import Data..."
3) Select your file and following & choice what Excel says to you.
I hope it is useful for you.
2007-12-27 00:05:46 · answer #2 · answered by Vnsoftprovider 2 · 0⤊ 0⤋
In homestead windows Explorer, kit, Folder thoughts, View uncheck disguise extensions for nicely-known report varieties. then you are able to form CSV quickly over TXT. Recheck disguise once you're achieved in case you do in contrast to seeing extensions each and all of the time.
2016-10-20 01:06:47 · answer #3 · answered by macfarland 4 · 0⤊ 0⤋