how to remove number from alphanumeric cell

Posted to microsoft.public.excel.worksheet.functions

Igneshwara reddy[_2_] Igneshwara reddy[_2_] is offline

external usenet poster

Posts: 68

how to remove number from alphanumeric cell

Hi,

I have few rows which are alphanumeric cells, I need to extract only the
numbers from the cell.

For Eg: One cell contains fjdslfdslflsd455646sdfds768468
Second cell contains fsdfsd4879899 fsdfdsf547555sdfds797988.

From this two cells I need to extract only numbers.

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
separating numbers from a alphanumeric cell	Igneshwara reddy[_2_]	Excel Worksheet Functions	3	March 12th 07 08:13 PM
Alphanumeric random number?	Michelle B	Excel Discussion (Misc queries)	6	November 7th 06 08:34 AM
Add number into one cell to remove from another cell.	Jeff	Excel Discussion (Misc queries)	0	September 22nd 06 06:24 PM
a tough question - calculating a number out of an alphanumeric code	usingexcel	Excel Discussion (Misc queries)	2	August 3rd 06 06:07 PM
how can I sort alphanumeric entries by number in excel	beasleyb	Excel Worksheet Functions	1	October 27th 05 10:17 PM

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

Menu

About Us