Hi Forum Colleagues

I am looking for a piece of code that will allow me to paste copied text into a worksheet using the Text to Columns functionality before I place it into a column. The delimiter will be a comma.

I need this because there will be some cells that will have more than 14 numbers separated by commas that I dont want Excel to treat as a number. They need to stay as text. An example of one row of data is:

365,366,428,416,417,418,419,420,421,422,424,425,42 6,427

Your help would be appreciated.

Many thanks in anticipation.

Tony