sudarshan1413
New Member
Hello Friends ,
I have one scenario.
Daily I paste thousands of rows in excel for analysis.
These all rows are in delimited(^) format.
So every time , I need to go to data import wizard and use delimeter(^) to import the data into excel.
When I am importing data into excel, I have one more thing to do i.e. to make every column as text , becuase i dont want to miss any value.
Can above scenario be made reusable , with macro or any other workaround for the same?
Thanks in advance!
Sudarshan
I have one scenario.
Daily I paste thousands of rows in excel for analysis.
These all rows are in delimited(^) format.
So every time , I need to go to data import wizard and use delimeter(^) to import the data into excel.
When I am importing data into excel, I have one more thing to do i.e. to make every column as text , becuase i dont want to miss any value.
Can above scenario be made reusable , with macro or any other workaround for the same?
Thanks in advance!
Sudarshan