extracting numerics from literal strings

Posted to microsoft.public.excel.programming

Ed[_16_]

external usenet poster

Posts: 4

extracting numerics from literal strings

If my cell A1 contains a string such as "Total 30 employees", how do I
extract the value (e.g. 30) from this string and put it in cell B1?

Thanks.

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
find and replace numeric strings in larger text strings	Mr Molio	Excel Worksheet Functions	8	November 9th 11 05:17 PM
Extracting specific data from Date and time strings	John Norfolk	Excel Discussion (Misc queries)	3	September 24th 08 09:52 AM
Extracting numbers from alphanumeric strings	Poonam	Excel Worksheet Functions	5	April 5th 08 01:27 AM
How to find number of pairs of strings from list of strings?	greg_overholt	Excel Worksheet Functions	5	January 27th 06 10:42 PM
2 more questions about extracting numbers from text strings	andy from maine	Excel Discussion (Misc queries)	0	March 28th 05 09:47 PM

All times are GMT +1. The time now is 02:36 PM.

About Us