Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to find all 9-digit numbers
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to find all 9-digit numbers
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to find all 9-digit numbers
On Mar 4, 3:00 pm, Ron Rosenfeld wrote:
On Tue, 4 Mar 2008 11:48:21 -0800 (PST), wrote: 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! 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 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to find all 9-digit numbers
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to find all 9-digit numbers
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 On Tue, 4 Mar 2008 11:48:21 -0800 (PST), wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering 16 digit numbers - last digit turns to zero | New Users to Excel | |||
Store numbers starting with zero as 2 digit numbers | Excel Discussion (Misc queries) | |||
what is the minimum numbers set for 4 digit numbers from 0000 to 9 | Excel Discussion (Misc queries) | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming |