View Single Post
  #5   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
use 'Data - Text to columns'

--
Regards
Frank Kabel
Frankfurt, Germany

"Brian" schrieb im Newsbeitrag
...
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.