davy999
asked on
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
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
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.
ASKER
Sounds good Paul
But how do i do that
But how do i do that
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
thanks Paul worked a treat
Could you send an example?
Regards