Can anyone show or direct me to a simple macro for a simpleton like to convert ASCII column values into separate column for each value? Say I copy/paste columns from and ASCII/txt file into an Excel worksheet in the column A. All the values go into this one column, so everytime I need to go through the tedious text to column option in Excel to put the values into separate cells. It can get pretty tiresome and time-consuming if I have to repeat this a lot - which I do at the moment. I just need a macro or a template that splits the tab or space delimted ASCII columns to separate Excel columns everytime I paste them into the first column (col A).
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
ASCII Columns to Excel Columns
- Thread starter Exceliber
- Start date
I forgot to add that importing the headings isn't that important for my purpose and, also, is there a way to make Excel open ASCII columns open in separate columns in one click of mouse?
Some of the things that the folks at MS haven't thought about or improved after all these years with making Excel are just beyond me.
Some of the things that the folks at MS haven't thought about or improved after all these years with making Excel are just beyond me.
Upvote
0
Similar threads
- Question
