{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 réponses

Texture issues in enshrouded

Driver his

Peritel to hdmi conversion

How to access the bios on a compaq notebook

Dsi won't turn on anymore

Search for a song with the lyrics

Left mouse click, touchpad click inactive

Codes stronghold crusader

Stuck computer system repair

Disable write protection mp3 player