|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
03-22-2007, 11:00 AM
|
|||
|
|||
|
Formatting Phone numbers
 Do you know of an easy formula or an Excel application or software than can format phone numbers for a voice broadcasting system? It must be able to: remove characters like (, ) , ., - ,/ +,\ and , and put the number 1 in front of all the numbers? Eg. (770)555-5992 or 770-555-5992 The outcome should be 17705555992 ….no brackets, no dashes, no commas, no periods, just straight numbers The formula or program must be "dummy easy" to impliment. _________________ 
|
|
#2
03-22-2007, 11:31 AM
|
||||
|
||||
|
Try something like this in B1,
="1"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","") then drag down column B
__________________
oldchippy -------------   Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
|
#3
03-22-2007, 12:28 PM
|
|||
|
|||
|
I am Still not clear
Quote:
How and where do I start? 
|
|
#4
03-22-2007, 12:33 PM
|
||||
|
||||
|
If your number start in A1, copy the formula and place it in B1, then drag the formula down column B - see link on entering formula's
http://www.contextures.com/xlDataEntry01.html#Mouse See how this goes, I may need to adjust for other characters
__________________
oldchippy ------------- Click here >>> Top Excel links for beginners to Experts Forum Rules >>>Please don't forget to read these
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
