Data/Text to Columns. Choose Fixed, click Next. click between the
desired digits. Click Finish.

In article ,
"Brian" wrote:

I have a column which contains 6 digit numbers (i.e. 123456).

I want to convert it into 3 columns of 2 digit numbers (i.e. Column A
=12,Column B=34,Column C=56).

Anyone know how?

Thank you.