How do I add spaces between numbers to an existing cell in excel?

Question

I have a number of cells with numbers but since they are phone numbers, i want to add spaces between them. What formula should i use to do this?

Thanks!

Answer 1

there are a couple of different ways you could display your numbers as an actual phone #.  Easiest way is to just create a "custom" format.  Format the cell then choose "custom", enter a format of ### ### ####.

This will display your number as "888 888 8888".   There is also a pre-defined custom format (under "special") for "Phone #" that will change it to show as "[phone]".

Or you could enter a formula of

=TEXT(A1, "### ### ####") (where A1 is the cell with your number)

this will display it as 888 888 8888

Answer 2

Excellent answer from jmorge. But I want to add one more method - start the number with apostrophe (') which will make the entry characters as oppose to numerals so that you can insert space which is also a character.