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.
_________________
Try something like this in B1,
="1"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-",""),"(",""),")","") then drag down column B
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
If my numbers are in colum... AOriginally Posted by oldchippy
How and where do I start?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks