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 remove the spaces it works. Is there a way to make it recognize the spaces? or should I create the list with out spaces and then is there a way to add the spaces to the entire column after it has been created?
Example of number 124 000 199 264 100
2 Replies
ChristyQuaedvlieg If adding the spaces is a mere cosmetic issue, you may custom format the 15-digit number as 000 000 000 000 000.
It will remain a number but just displayed with spaces between every group of three digits.
- 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.
