Hello tac45,
Welcome to our ExcelDemy Forum! Based on your post, I understand you wish to put 'x' blank spaces between your numbers and texts. You can easily do that using some functions in Excel. Please apply the mentioned formula to do that.
=LEFT(A1,6)&REPT(" ", 6)&RIGHT(A1,LEN(A1)-6)...