Excel Phone Number Hyphen Insertion
Excel Phone Number Hyphen Insertion
(OP)
I have scrounged several thousand phone numbers off a database.
Able only to put the 10 digit phone numbers into one cell.
Is there a method to insert the hyphens into the phone numbers so they are easier to read?
Other than hard work that is.
Thank you for all the past help you guys have been.
Able only to put the 10 digit phone numbers into one cell.
Is there a method to insert the hyphens into the phone numbers so they are easier to read?
Other than hard work that is.
Thank you for all the past help you guys have been.
PUMPDESIGNER





RE: Excel Phone Number Hyphen Insertion
The following formula will do the trick.
="("&MID(A1,1,3)&")"&MID(A1,4,3)&"-"&MID(A1,7,4)
A1 is the cell with the 10 digit phone number.
Bill
RE: Excel Phone Number Hyphen Insertion
Format-Cell-Number(tab)-Custom
Type ###-###-#### into the "Type" box.
-InspEngr
RE: Excel Phone Number Hyphen Insertion
2. From the menu select:
Format>Cells>Number>Special>Phone Number
This should format the ten-digit phone numbers in the standard phone no. format i.e.
'(###) ###-####'
'Dare to Imagine'
Mala Singh
RE: Excel Phone Number Hyphen Insertion
RE: Excel Phone Number Hyphen Insertion
You can also create a calculated field in the dBase/SQL query and export the information in the format you want. I've done both depending on what was needed.
In an Access report you can actually add the parentheses and the dashes in the report leaving the raw data alone. If you are exporting data from some large application have your IS person write the query and save it so that the information comes out with the same format every export.
I used to download data from a mainframe on a daily basis and used the data to update multiple database tables. The data was then queried to supply information to supplies for MRP/requirement data. I would compress the data and encrypt it and the suppliers could pickup the data from a website which held the files for the suppliers. I furnished a program to the suppliers which would unecrpyt and uncompress the data and put it in a table and could view the data. It was a poor man's EDI.
RE: Excel Phone Number Hyphen Insertion
Yup, works great.
I tried many ways thinking Excel would surely have some formatting, but nothing I tried worked.
Thank you.
PUMPDESIGNER
RE: Excel Phone Number Hyphen Insertion
Mala Singh
'Dare to Imagine'
RE: Excel Phone Number Hyphen Insertion
Mala Singh
'Dare to Imagine'