Excel 2010 phone number prefix formula macro
Posted on 2011-02-14
I thought I was pretty good with excel formulas until someone asked me for this one!
I have a list of phone numbers in a spreadsheet. They are all in number only format: xxxxxxxxxx. No parentheses, dashes, spaces, etc.
What I need to do is put a prefix with the number “1” for every line EXCLUDING some specific area codes. For example:
Only the first six rows should have a 1 prefix. When I am done, it needs to look like this:
Obviously the following area codes are local and therefore do not require a 1 by the auto dialer: 954, 305, 561, 786. More may be added later, so I also need a way to modify the exclusion list.
Yes, I know I could easily sort the list and run a concatenate formula, but the list is huge and is updated daily. I need to make this a macro that can be run daily by an end user… someone absolutely oblivious to excel formulas… I would rather it be a macro than a VBA script, if possible.
BYW – this is not for spamming or debt collections, it’s strictly for “good” purposes!
Thanks in advance!!!