All Questions
17
questions
2
votes
1
answer
17k
views
Excel How to make Text Qualifier editable or add a new entry in the existing list?
I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
"...
- 753
2
votes
3
answers
6k
views
Fast way to export data out into different excel files based on Column
There's some data like this (with over 500,000 entries)
Name | State
---- -----
Billy Utah
Sue California
Joe Utah
Sally California
John Michigan
...
- 95