| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add area code to phone numbers in ranges
I have a worksheet that has telephone numbers in two seperate columns. I'd like to locate all the 7-digit numbers (those without area codes) in both columns and then add a specific area code to all those numbers. Any number encountered that already has 10 digits I'd like to ignore and leave alone. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=514634 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
| Deleting the area code on excel spread sheet phone numbers?? | Excel Discussion (Misc queries) | |||
| adding a phone area code that is not there | Excel Discussion (Misc queries) | |||
| How do I add an area code to a list of phone numbers in Excel? | Excel Worksheet Functions | |||
| Adding Area Code To Phone Numbers | Excel Programming | |||
![JimDandy[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
