I'm trying to clean up some data that contains phone numbers that were
exported out of a employee database and imported into an Excel file. Each
employee's data makes up one row of data in the Excel file, and the phone
numbers of all employees are in cells in one column. The phone numbers for
some employees have the area code while the area code is missing in the phone
numbers for the other employees. Is there some method, other than manually
editing each cell containing a phone number that's missing the area code,
that I can use to add the area code to only those employee phone numbers that
are missing the area code?
--
Thanks,
RC

Is your data text or numbers??? If it is text exactly what does it look like???
--
HTH...

Jim Thomlinson


"RC" wrote:

> I'm trying to clean up some data that contains phone numbers that were
> exported out of a employee database and imported into an Excel file. Each
> employee's data makes up one row of data in the Excel file, and the phone
> numbers of all employees are in cells in one column. The phone numbers for
> some employees have the area code while the area code is missing in the phone
> numbers for the other employees. Is there some method, other than manually
> editing each cell containing a phone number that's missing the area code,
> that I can use to add the area code to only those employee phone numbers that
> are missing the area code?
> --
> Thanks,
> RC

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


"Jim Thomlinson" wrote:

> Is your data text or numbers??? If it is text exactly what does it look like???
> --
> HTH...
>
> Jim Thomlinson
>
>
> "RC" wrote:
>
> > I'm trying to clean up some data that contains phone numbers that were
> > exported out of a employee database and imported into an Excel file. Each
> > employee's data makes up one row of data in the Excel file, and the phone
> > numbers of all employees are in cells in one column. The phone numbers for
> > some employees have the area code while the area code is missing in the phone
> > numbers for the other employees. Is there some method, other than manually
> > editing each cell containing a phone number that's missing the area code,
> > that I can use to add the area code to only those employee phone numbers that
> > are missing the area code?
> > --
> > Thanks,
> > RC

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 <(E-Mail Removed)> wrote:

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

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 <(E-Mail Removed)> wrote:
>
> >Thanks, Jim, it's text with the dashes, and look like the following:
> >229-123-4567
>
>