- Create a false .csv file with the same number of columns. put text data in the first row, and save.
- With a blank worksheet in Excel, us the Data-Get & Transform date-From Text/CSV function to import the false .csv file. It will import as text.
- Save as a worksheet & close.
- Save the real .csv file over the false .csv file
- Re-open the worksheet, click on a data field, select Refresh in the Table Tools Ribbon.
- Automate, as desired.
H
HoviWan
@HoviWan
3
Reputation
1
Posts
20
Profile views
0
Followers
0
Following
Best posts made by HoviWan
-
RE: Excel is fundamentally broken.
Latest posts made by HoviWan
-
RE: Excel is fundamentally broken.
- Create a false .csv file with the same number of columns. put text data in the first row, and save.
- With a blank worksheet in Excel, us the Data-Get & Transform date-From Text/CSV function to import the false .csv file. It will import as text.
- Save as a worksheet & close.
- Save the real .csv file over the false .csv file
- Re-open the worksheet, click on a data field, select Refresh in the Table Tools Ribbon.
- Automate, as desired.