Need to find all 9-digit numbers

  • Thread starter Thread starter alfred.cloutier
  • Start date Start date
A

alfred.cloutier

In a single column, I need to be able to find all nine-digit numbers.
All the numbers are different, but they all have nine digits. It seems
like I could do this in Word, but I can't figure out how to do it in
Excel.

Thanks!
 
In a single column, I need to be able to find all nine-digit numbers.
All the numbers are different, but they all have nine digits. It seems
like I could do this in Word, but I can't figure out how to do it in
Excel.

Thanks!
Click to expand...

Typing FIND into the help bar and select Find text or numbers.

You can use wildcard characters so you would type ????????? (9 ?'s) into the
Find What box; and also select <match entire cell contents> under Options.

--ron
 
Typing FIND into the help bar and select Find text or numbers.

You can use wildcard characters so you would type ????????? (9 ?'s) into the
Find What box; and also select <match entire cell contents> under Options.

--ron
Click to expand...


Ron, thanks! I figured that was the only way to do it. I wanted to
know if I could search specifically for nine *digits* because nine
letters also gets found.

Thanks again!
 
Ron, thanks! I figured that was the only way to do it. I wanted to
know if I could search specifically for nine *digits* because nine
letters also gets found.

Thanks again!
Click to expand...

If you need to confine to digits, you'll have to use VBA
--ron
 
Non-VBA solution

=AND(ISNUMBER(A1),LEN(A1)=9) entered in B1 and double-clicked to copy down.

Will return true or false.


Gord Dibben MS Excel MVP
 
Back
Top