Posted to microsoft.public.excel.programming

johnrb7865 johnrb7865 is offline

external usenet poster

Posts: 20

finding numbers

Hi, does anyone know how I would pull numbers out of a string of text? For
example, the text: Prepare Culvert Pipe (30 Inch), I need a formula to
display just the "30". The text strings will vary so I cannot use MID to pull
out text at certain spots. Any thoughts?

Thanks,
John

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
finding case numbers	em	Excel Worksheet Functions	2	August 24th 09 02:31 PM
Finding Duplicate Numbers	chadhable	Excel Discussion (Misc queries)	1	May 16th 08 12:47 AM
Finding numbers or numbers and dashes in text	[email protected]	Excel Programming	6	April 2nd 07 12:10 PM
Finding Row Numbers Within the RangeName	Goofy	Excel Programming	4	October 19th 06 09:42 AM
finding numbers	flat6	New Users to Excel	2	February 17th 05 10:17 PM

All times are GMT +1. The time now is 04:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us