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