Posted to microsoft.public.excel.misc

Confused_in_Houston[_2_] Confused_in_Houston[_2_] is offline

external usenet poster

Posts: 15

Extracting Numerals From a Text String?

I have several thousand Material Description entries that contain a mix of
text and numerals.

For example: Gasket, high-melt, DLL84848

In the example I would like to ignore the text and simply extract the 84848.
The numbers will not always be in the "last" position; formatting varies
considerably. Is there a way for Excel to recognize numerals in a string of
text?

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
Extracting h:mm:ss from text string	Micki	Excel Worksheet Functions	19	January 26th 09 05:26 PM
Extracting text from a string	[email protected]	Excel Worksheet Functions	8	June 2nd 08 10:09 PM
Extracting text from string	Confused	Excel Worksheet Functions	4	February 15th 08 03:34 PM
Extracting a numbers from a text string	IPerlovsky	Excel Worksheet Functions	24	February 27th 07 04:55 PM
Extracting from a text string	AmyTaylor	Excel Worksheet Functions	3	June 24th 05 01:34 PM

All times are GMT +1. The time now is 04:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us