Excel – Add space between numbers in Excel

cell formatformatmicrosoft excel

How to I add space automatically to a 22-digit number?

For example: 1234567891234567891234 needs to be formatted
to 123456 7891234567891234 (basically added a space after 6).

Best Answer

Excel only allows up to 15 significant digits so a 22-digit number can only be represented in Excel as a text value, hence you can't use number formatting. To get the required result in another cell you can use REPLACE function to add a space at character 7, i.e.

=REPLACE(A1,7,0," ")

Related Question