Posted to microsoft.public.excel.misc

Corey

Posts: n/a

Extract Numerics only

Hello. I have a column with data that contain numerics and text:

ON 3127
ON2679
O/F 20R
OFF///130H

Is there a formula I can input in an adjacent cell to only pull out the
numbers to give me the following:

3127
2679
20
130

Any help is appreciated. 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
Extract sub string	sixbeforedawn	Excel Worksheet Functions	2	October 24th 05 09:50 AM
VBA code to extract m-coefficient in linear trendlines from ALL charts	willinusf	Excel Discussion (Misc queries)	3	July 12th 05 09:54 PM
Trendline Extract	Phil Hageman	Charts and Charting in Excel	5	July 6th 05 02:27 AM
Extract Unique Values, Then Extract Again to Remove Suffixes	Karl Burrows	Excel Discussion (Misc queries)	23	June 25th 05 10:37 PM
Extract specific data into its own workbook via macro?	Adrian B	Excel Discussion (Misc queries)	2	February 24th 05 06:09 AM

All times are GMT +1. The time now is 09:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us