PC Review


Reply
Thread Tools Rate Thread

Adding area codes only to phone numbers missing an area code

 
 
RC
Guest
Posts: n/a
 
      12th Feb 2008
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
 
Reply With Quote
 
 
 
 
Jim Thomlinson
Guest
Posts: n/a
 
      12th Feb 2008
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

 
Reply With Quote
 
RC
Guest
Posts: n/a
 
      12th Feb 2008
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

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      12th Feb 2008
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


 
Reply With Quote
 
RC
Guest
Posts: n/a
 
      12th Feb 2008
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

>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
area codes is auto filling my own 9 digit ph# vs just area code Computer Dummy Microsoft Outlook Contacts 1 28th Jan 2010 10:58 PM
Adding Area Codes to Phone Numbers Scott Salt Lake Microsoft Outlook Contacts 1 1st May 2009 11:11 AM
Sorting phone numbers by area codes and prefix =?Utf-8?B?TW9zZXM=?= Microsoft Access 1 27th Nov 2006 09:09 PM
Adding Area Code To Phone Numbers Minitman Microsoft Excel Programming 2 21st May 2004 05:43 PM
HELP!! adding Area codes with phone numbers and state HELP Alpha51 Microsoft Excel Misc 2 4th Dec 2003 05:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:17 AM.