Solved

find phone numbers in excel

Posted on 2016-10-04
6
45 Views
Last Modified: 2016-10-04
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
Comment
Question by:davy999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 41827635
Hi,

Could you send an example?

Regards
0
 
LVL 1

Expert Comment

by:Paul Thomson
ID: 41827642
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
 
LVL 6

Author Comment

by:davy999
ID: 41827646
Sounds good Paul

But how do i do that
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Accepted Solution

by:
Paul Thomson earned 500 total points
ID: 41827651
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
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 41827744
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
 
LVL 6

Author Closing Comment

by:davy999
ID: 41827761
thanks Paul worked a treat
0

Featured Post

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question