| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
area code
I have one column that has list of phone numbers with area code. I
need to make new column for which state. I would like to make a small macro program to check the area code and put two letters state on new column. How do we do that. I was thinking to use loop for read each row and use if area code = (301) then row 1 = CA elseif area code = (302) then row 1 = UT.... I don't know where to start.. |
| 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) | |||
| worksheet code area | Excel Discussion (Misc queries) | |||
| Zip Code/Service Area help | Excel Discussion (Misc queries) | |||
| VBA code for set print area | Excel Programming | |||
| Set print area with code | Excel Programming | |||
Threaded Mode
