Inserting characters into text already typed

  • Thread starter Thread starter rabbithowling
  • Start date Start date
R

rabbithowling

I made a list of phone numbers without the parenthesis and dashes and
spaces figuring I would format the numbers later with the special phone
number format. But now I want to actually input all the parenthesis,
dashes and etc. into the plain numbers typed in the cells. Any
suggestions? Thanks in advance.
 
I made a list of phone numbers without the parenthesis and dashes and
spaces figuring I would format the numbers later with the special phone
number format. But now I want to actually input all the parenthesis,
dashes and etc. into the plain numbers typed in the cells. Any
suggestions? Thanks in advance.
Click to expand...

You might be able to use the TEXT function.

If your entry is 8005551212 (in A1), then:

=TEXT(A1,"1-(000) 000-0000")

--> 1-(800) 555-1212
as a text string


--ron
 
Select the cells.....Right-click > FormatCells > NumberTab > Special >
PhoneNumber > OK

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone Number Excel 2003 7
extract a phone number from formatting 3
Formula for extracting text formated numbers within ( )'s as numbe 5
Is there a quick way to format a phone feild in a form 3
text to numbers 1
Convert number to ph # for mail merge (updated) 2
Convert number to phone number 1
Formating phone numbers in cells 2

Back
Top