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
 
Back
Top