Adding area codes only to phone numbers missing an area code
Thanks Gord, the formula did the job!
--
Thanks again,
RC
"Gord Dibben" wrote:
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
|