Solved

find phone numbers in excel

Posted on 2016-10-04
6
48 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 51

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
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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 11

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

695 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