Copy Code

=TEXTJOIN(" ", TRUE, LEFT(TEXT(A1, "00000000000"), 2), MID(TEXT(A1, "00000000000"), 2,2), MID(TEXT(A1, "00000000000"), 4,1), MID(TEXT(A1, "00000000000"), 5,3), RIGHT(TEXT(A1, "00000000000"), 3))

The reference A1 in the formula should be altered to the cell reference containing your number. Once you have pasted the formula in the first cell of the new column, you can just use Excel's auto copy to repeat it for the entire column.

Also note that if the original column contains a text string rather than a numeric value then you can use the simplified formula:

Copy Code

=TEXTJOIN(" ", TRUE, LEFT(A1, 2), MID(A1, 2,2), MID(A1, 4,1), MID(TEXT(A1, 5,3), RIGHT(A1, 3))