Solved

# Convert Ph Numbers

Posted on 2014-04-01
148 Views
Hello experts,

What's the best way to convert phone numbers, e.g. (513) 555-1212 to straight digits (see sample for addnl conversions)?  Keep it simple.

Note some phone numbers end with zeros.

Thanks,
Gary
Profit-Center-Master-List-EE-4-1.xlsx
0
Question by:garyrobbins

LVL 23

Accepted Solution

NBVC earned 500 total points
ID: 39970351
A few nested SUBSTITUTE functions:

in B2:

=TRIM(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"+",""),"(",""),")",""),"-","")," ",""),".",""))

Or if you want to do it in-situ,

Select Column, then CTRL+H  replace each character with nothing, one at a time.
0

Author Closing Comment

ID: 39970484
NBVC,
thanks for the simple solution.
is-situ -- dah1

Gary - Cincinnati
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calculâ€¦
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaacâ€¦