All Questions
25
questions
0
votes
1
answer
268
views
running 2 excel versions at once, cant associate filetype to older version
I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...
- 1,173
2
votes
0
answers
713
views
Open Colon delimited file from command line in Excel
I want to create a shortcut or a command to open a file that uses a colon : as a delimiter in excel.
I know via the UI I can
click "From Text/CSV"
select a file
click Import
select a ...
- 121
1
vote
1
answer
148
views
Certain Time Values in a .xlsx not Changing When I convert to a .csv
I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
- 13
2
votes
2
answers
6k
views
Convert comma delimited, key-value pairs in single column into different columns
I have a column in an excel sheet that contains value formatted like the following:
"Key1":"Value1","Key2":"Value2","Key3":"Value3"..
I have many rows of this data. I would like to break these keys ...
1
vote
1
answer
259
views
How to sort number of numeric columns in one go
I have 350 columns. Below is a subset of all the data.
I used "Sort Smallest to Largest" tool. It gives results only for one column. If not, it can sort the first column and other columns will ...
- 11
1
vote
3
answers
2k
views
Separating comma delimited data from one cell to multiple cells when the entry is a live data link
My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing:
=RTD("rit2.rtd",, "...
-1
votes
1
answer
35
views
Place a String separated by commas into the Excel rows
I have a String like this separated by the commas:
id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
- 523
6
votes
3
answers
69k
views
How to make excel open CSV files and automatically split the comma delimited column?
I get these reports everyday in CSV format. In the previous version of excel (2007) when I opened these files they were already split into columns. Now with the latest version it isn't. Where is this ...
- 171
0
votes
1
answer
31k
views
Editing CSV file in Excel always converts number column to scientific notation [duplicate]
I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
- 101
0
votes
0
answers
39
views
Excel converts comma delimited to tab delimited when saving [duplicate]
I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
- 101
0
votes
1
answer
2k
views
Export multiple (specific) worksheets to CSV files in a specified directory
I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected.
Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file ...
- 1
1
vote
1
answer
251
views
csv file formatting issue in excel
I have a csv file when opened in notepad looks like this:
sep=,
ProgramXX, PXXXXX, ....
IDXXXXX, XYZXXXXX, ....
This should open well formatted as csv file in excel program but what I see is this:
...
0
votes
1
answer
387
views
Can I create a cell with enumerated values in a csv file
Can I create a cell with enumerated values in a csv file?
For example, I want a cell that can only get the values:
a) "value1"
b) "value2"
c) "value3"
Is this possible?
PS:
I have used this ...
2
votes
1
answer
2k
views
Excel inconsistent date conversion
I'm running Excel 2007.
I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: 39262....
- 165
0
votes
1
answer
4k
views
Deleting entire row in excel if missing data in certain column or columns?
I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
- 380