Menu

Need to find all 9-digit numbers

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Ron Rosenfeld Ron Rosenfeld is offline

Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Default

Need to find all 9-digit numbers

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering 16 digit numbers - last digit turns to zero	dreamer	New Users to Excel	4	May 9th 09 01:04 AM
Store numbers starting with zero as 2 digit numbers	twisted1825	Excel Discussion (Misc queries)	8	January 11th 07 06:41 PM
what is the minimum numbers set for 4 digit numbers from 0000 to 9	Ambika	Excel Discussion (Misc queries)	14	January 27th 06 10:50 PM
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO	jnkell	Excel Worksheet Functions	2	December 18th 04 07:13 PM
find and delete text, find a 10-digit number and put it in a textbox	Paul	Excel Programming	3	November 16th 04 04:21 PM

All times are GMT +1. The time now is 03:57 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement