Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • 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
Technology Partners: 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!

 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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