Aug 17 2020 06:15 AM
Good day Excel Community!
I am trying to import .txt in Excel app from Data > Get & Transform Data > From Text/CSV. I was able to do it using the traditional way, in which I was able to select/adjust specific columns. Here is a screenshot provided:
But when I got to Data > Get & Transform Data > From Text/CSV, I cannot seem to select/adjust specific columns.
Please help me on this.
Thanks. :)
Aug 17 2020 08:33 AM
Aug 17 2020 11:20 AM
Aug 20 2020 04:02 AM
In general it shall work.
If after changing the numbers you click on Refresh icon, numbers will be returned in initial one. However, if instead to click on any empty cell in preview window, new numbers will be taken to show how the text is split.
Alternatively you may Transform and correct numbers in formula bar.