Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 65
  • Last Modified:

find phone numbers in excel

Hi all

A customer has given me a list of phone numbers and e-mail ect in excel and he wants to find the contacts by there phone
numbers whats the best  and easiest way to do this

thanks Davy
0
davy999
Asked:
davy999
1 Solution
 
Rgonzo1971Commented:
Hi,

Could you send an example?

Regards
0
 
Paul ThomsonHead of ICT GovernanceCommented:
Easiest way is to put filters on your header row and when you want to find a phone number click the drop down arrow on the header and enter some of the phone number digits into the search bar.
0
 
davy999Author Commented:
Sounds good Paul

But how do i do that
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Paul ThomsonHead of ICT GovernanceCommented:
I'm using Excel 2010... I would highlight the header cells I want to add filter to, select the DATA ribbon and click the FILTER button. This will then add filtering to the highlighted cells.

To use this see picture attached.
Excel-Filtering.jpg
0
 
HuaMinChenBusiness AnalystCommented:
Hi,
You can have loop to scan through the Worksheet and check if the cell is having numbers inside and is with length like 8 digits.
Use numeric is check if cell value is numeric.
0
 
davy999Author Commented:
thanks Paul worked a treat
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now