sunhux
asked on
how to import in a text separated file & use macro to move columns 2 & 3 to be under column 1
I'm on Excel 2016: I recall I ever see in older Excel there's a way to import
by "space separated" but I can't locate it currently.
Anyone can give me step by step instruction on how to do this?
I have a text file (output from 'net user /domain > file.txt') that has 3
columns of text, the 3 columns are separated by spaces
After that would like a macro that reads in the 3 column data that will
automatically move columns 2 & 3 to be under column 1 , resulting in
a single column of data & if saving can be automated, save as text
by "space separated" but I can't locate it currently.
Anyone can give me step by step instruction on how to do this?
I have a text file (output from 'net user /domain > file.txt') that has 3
columns of text, the 3 columns are separated by spaces
After that would like a macro that reads in the 3 column data that will
automatically move columns 2 & 3 to be under column 1 , resulting in
a single column of data & if saving can be automated, save as text
The Get Data button is on the extreme left of the Data Tab in the Ribbon
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much.
Anyone has the macro to move the columns?
Anyone has the macro to move the columns?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When I click on "Data" tab, don't see any option for 'Get External Data'