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?
For the collection:
If numbers are in the column, they could be split by Data->Text to Columns with fixed width and destination into another columns.
To combine back as
=SUMPRODUCT(B1:J1*{100000000,10000000,1000000,100000,10000,1000,1000,10,1})Like this