Forum Discussion
Numbers with spaces in them
I have to create a sheet with consecutive15 digit numbers. When I enter the 15 digit number with spaces between every third number excel will not let me create a list with consecutive numbers. If I ...
You could create the list w/o spaces and then put the spaces in using a formula (assuming all of the numbers are 15 digit).
=TEXTJOIN(" ",,MID(A1,{1,4,7,10,13},3))
Then, copy/paste special value to hardcode the formula results and you could get rid of the numbers w/o spaces.
=TEXTJOIN(" ",,MID(A1,{1,4,7,10,13},3))
Then, copy/paste special value to hardcode the formula results and you could get rid of the numbers w/o spaces.