Thread: I have a col. with 6 digit nos to convert to 3 cols of 2 digits
View Single Post
  #1   Report Post  
Brian
 
Posts: n/a
Default I have a col. with 6 digit nos to convert to 3 cols of 2 digits
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.
Reply With QuoteReply With Quote