31 мар. 2012 г. · Go to the Data tab and select text to columns under data tools then select delimited and hit next. Then select comma as the delimiter and ...

15 нояб. 2016 г. · How to make excel open CSV files and automatically split the comma delimited column? · You can do this by selecting Data ---> Text to columns.

26 авг. 2010 г. · In Excel 2003 goto Data -> Import External Data -> Import Data on the menu bar (can't say where it is on 2007, I don't have that to hand at the ...

17 мая 2017 г. · I tried this using excel 2016. I opened Excel - Select File,open selected the "CSV" file and selected delimited, Semicolon as the separator ...

14 июл. 2014 г. · In Notepad, go to Edit->Replace.... In 'Find what:', type a comma. In 'Replace with:', type the character you want to use for the separator. The ...

11 июл. 2011 г. · Make sure there a no spaces between your separated values and wrap each field in quotes: "1, 2","3, 4". Will import into 2 cells - the first ...

13 апр. 2010 г. · Highlight the cells you want to add the quotes. Go to Format –> Cells –> Custom Copy/Paste the following into the Type field: \”@\” Click “okay” ...

24 нояб. 2013 г. · The problem you're having is because when xcel saves a sheet as CSV, it actually separates the values with a semicolon (;) and not a comma.

11 сент. 2015 г. · Open your CSV file in Excel > Find and replace all instances of double quotes ( " ). Follow the instructions provided in this ...

1 мая 2016 г. · Values that contain commas must be wrapped in double quotes for comma separated processing. Look at the following CSV sample and how it resolves ...