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).