?
Solved

find phone numbers in excel

Posted on 2016-10-04
6
Medium Priority
?
52 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 52

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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 1

Accepted Solution

by:
Paul Thomson earned 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

770 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