View Single Post
  #3   Report Post  
Jason Morin
 
Posts: n/a
Default

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

.