All Questions
4
questions with no upvoted or accepted answers
3
votes
0
answers
117
views
Excel csv-import into table referenced by name
I have a worksheet called raw_data where I import some data via the Data-Import Wizard. This created a new name-referenced range called abc.csv.
However if I try to create a table on another ...
2
votes
0
answers
2k
views
Is it possible to make Excel auto-filter case sensitive?
I have a CSV file I opened with Excel 2013 because I wanted to find errors in a specific column.
Here is an extract of data:
"ID";"LANGUAGE";"TYPE";"NAME";"ACTIVE";"CITY";"POSTAL_CODE";"...
0
votes
0
answers
110
views
Excel is placing commas where it shouldn't
I'm working with climatic data from a bunch of counties around the country. The data is originally on the .csv format, and when I open it, I get a different result than my co-workers. Apparently my ...
0
votes
0
answers
751
views
Excel 2013 keeps removing commas from CSV at save
I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...