{EXCEL} Insert spaces in phone number

Question

Hello, I would like to insert a space between every 2 digits of a series of phone numbers in an Excel (2003) field. Does anyone have a solution? Thank you in advance for your help

fiu · Accepted Answer

Hi,  you can use the display format 00" "00" "00" "00" "00  if it's for a conversion, you need to use =TEXT(number; "00"" ""00"" ""00"" ""00"" ""00")

fiu · Answer

... of precision!? oh! the big cauldron that I am! I didn’t explain where I come from number, did I?

spectrum200 · Answer

Hello, don't blame yourselves, especially since you would be one of those night owls who are still working at 4:30 in the morning... Hats off!
Actually, I know where to find it in the cell format "Text," but indeed I don't see the correspondence with "Number"
See you!

fiu · Answer

Hi

the announced time is CCM time, not necessarily mine (CCM is not - yet - reserved for the French).
otherwise, it's exactly what I was saying: I didn't present number, so you're lost.
so, I'm going to set you on the right track: since you're using Excel, I provided an Excel format & an Excel formula (and to avoid any confusion, I separated them with a blank line). I thought you'd guess since formulas always start with the symbol =
for more details, as usual, I'll let you check the help

potiok · Answer

Hello,
to display a number with spaces, just select the cell (or the column...), right-click, go to cell format and in the "Number" tab click on "Special," there are phone numbers
have a nice day
--
here, it's a real circus lol

spectrum200 · Answer

Thank you potiok,
I have already tried this method before but it gave absolutely nothing.
We have the option to put a comma and I believe that’s all.
So to summarize. I need a space between every 2 digits. For example: 04 66 35 72 20
Here are some numbers from my column which now has more than 5000.
HELP!

0466357220
0466370236
0466371451
0466390200
0466500102

potiok · Answer

I think I know why... when you choose your phone format, which country are you in? I'm in France, so it works ;) -- here, it's the court of miracles lol

Albert · Answer

Hello  Read Potiok's post again and try again, that's the right method. When you ask a question, the least you can do is read the answers carefully and give it a try.

spectrum200 · Answer

Listen, dear Alibert...
When I said that I have already tried and retried and that it didn’t work, that’s how it is.
At the same time, I am replying to Potilok who is a bit nicer and doesn’t judge me (harshly) right off the bat that I am doing well in France and that I am using Excel 2003.
So here is exactly what I did:
1 - Right click on the column to highlight my numbers
2 - Format Cells
3 - Under the "Number" tab, I clicked on "Special" and in the "Type" box, I selected "Phone Number" and then clicked OK... nothing happened.
Surely there might be another problem, but which one?

potiok · Answer

Sorry to insist on this, but below types, you have regional settings, what’s there? If it takes 0 first, that’s a good start ;) -- Here, it’s the land of miracles lol

Nico · Answer

Good evening Do the other special formats work?

spectrum200 · Answer

And no, nothing is moving.

Nico · Answer

Look at what happens when you remove the leading zero from one of the numbers!

Nico · Answer

I believe I would proceed as follows:
Assuming the existing numbers in cells B10 to B20
- assign the phone format to column C
- write in C10: =CNUM(B10)
- the number must be formatted
- copy C10 to C11 to C20
- Select C10 to C20
- copy
- Select B10
- special paste values
- clear column C

yaga91 · Answer

To keep it simple: In the cell format, choose "Custom" in the type field enter: 00" "00" "00" "00" "00

{EXCEL} Insert spaces in phone number

15 answers

Long wait for the first internet connection

Inactive user

Platinum take beogram 1000 not compatible with mains power

Lost song

Texture issues in enshrouded

Installing linux on hp elitebook 1030 g3

Motorola g6

Unwanted video on android home screen

Retrieve old emails in gmail

I want to deactivate my account