Posted to microsoft.public.excel.worksheet.functions

Hardeep_kanwar[_2_] Hardeep_kanwar[_2_] is offline

external usenet poster

Posts: 103

extract number from alphanumric

Hi! Everybody

i have number of alphanumric list

For ex. asde1258rfgtt125
iqewr1258erer1258
kpijs780025dfdfd789

And so on
how can i extract only numbers
For example-1258125
12581258
780025789

Thanks in Advance

Hardeep kanwar

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 the row number	Hilton	Excel Worksheet Functions	4	October 4th 07 03:17 PM
extract number	smonsmo	Excel Discussion (Misc queries)	5	January 24th 07 12:14 PM
How do I select the last alphanumric word in an excel column with.	Puzzled Excel User	Excel Worksheet Functions	2	October 26th 06 11:34 PM
Extract number from text/number string..	nastech	Excel Discussion (Misc queries)	5	July 5th 06 11:21 PM
How to extract the Number from a String	johnbest	New Users to Excel	3	December 19th 05 06:23 PM

All times are GMT +1. The time now is 11:42 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us