Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • Last Modified:

Convert Ph Numbers

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
garyrobbins
Asked:
garyrobbins
1 Solution
 
NBVCCommented:
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
 
garyrobbinsAuthor Commented:
NBVC,
thanks for the simple solution.
is-situ -- dah1

Gary - Cincinnati
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now