| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I add an area code to a list of phone numbers in Excel?
I have multiple lists containing phone numbers that don't include an area
code. Is there a way to automatically add the same area code to the list? Thanks |
|
#2
|
|||
|
|||
|
yes. Assuming your list is is column A, with the first entry in cell A1, and you wish to add area code "01902"
enter the following into cell B1, ="01902"& A1 then copy and paste down. "PPuser" wrote in message ... I have multiple lists containing phone numbers that don't include an area code. Is there a way to automatically add the same area code to the list? Thanks |
|
#3
|
|||
|
|||
|
Try something to the effect of:
=IF(LEN(A1)<=8,"(404) "&A1,A1) HTH Jason Atlanta, GA -----Original Message----- I have multiple lists containing phone numbers that don't include an area code. Is there a way to automatically add the same area code to the list? Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| How do you create a list with name address phone in a column form. | Excel Discussion (Misc queries) | |||
| How can I cross reference phone numbers with existing phone numbe. | Excel Discussion (Misc queries) | |||
| How do I color code items in a drop down list? | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Hybrid Mode
