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

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" <PPuser@discussions.microsoft.com> wrote in message news:D3C87DFB-5BD2-4939-B49F-C1A311E2782E@microsoft.com...
>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
>

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
>
>.
>