Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding area codes only to phone numbers missing an area code
I'm trying to clean up some data that contains phone numbers that were
exported out of a employee database and imported into an Excel file. Each employee's data makes up one row of data in the Excel file, and the phone numbers of all employees are in cells in one column. The phone numbers for some employees have the area code while the area code is missing in the phone numbers for the other employees. Is there some method, other than manually editing each cell containing a phone number that's missing the area code, that I can use to add the area code to only those employee phone numbers that are missing the area code? -- Thanks, RC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting the area code on excel spread sheet phone numbers?? | Excel Discussion (Misc queries) | |||
Phone with/without area code format | Excel Worksheet Functions | |||
zipcode phone # area code/prefix problem | New Users to Excel | |||
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 |