Forum Discussion
copy and paste digit into multiple cells
Is there any way to copy a 9 digit number that is in one cell and paste it into 9 separate cells, one digit in each cell, and vice versa?
In order to separate a 9 digit number into one digit per cell, assuming the number is located in cell A1, you may use this formula (copy over 9 columns):
=MID($A$1,COLUMN(A:A),1)
In order to join 9 separate numbers, assuming the numbers are located in the range A1:I1, you may use this formula:
=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1)
=MID($A$1,COLUMN(A:A),1)
In order to join 9 separate numbers, assuming the numbers are located in the range A1:I1, you may use this formula:
=CONCATENATE(A1,B1,C1,D1,E1,F1,G1,H1,I1)