View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Adding area codes only to phone numbers missing an area code

Assuming area code is the same for each employee.

=IF(LEN(A1)=8,"229-"&A1,A1)


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 11:37:01 -0800, RC wrote:

Thanks, Jim, it's text with the dashes, and look like the following:
229-123-4567