Forum Discussion

Deleted

May 03, 2018

Format to display 20 numbers in groups of four

What format can I use in order to display 89462046211305792124 (20 numbers) as "8946 2046 2113 0579 2124" (displayed in group of four digits)?

Silver Contributor

May 03, 2018

Erik,

you could type the digits with the spaces.

Or you could use Power Query or Flash Fill or a formula:

=REPLACE(REPLACE(REPLACE(REPLACE(A1,17,0," "),13,0," "),9,0," "),5,0," ")