On Wed, 11 Apr 2007 10:08:05 -0700, Igneshwara reddy
wrote:

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.

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

You can then use this formula:

=REGEX.SUBSTITUTE(A1,"\D")

fjdslfdslflsd455646sdfds768468 455646768468
fsdfsd4879899 fsdfdsf547555sdfds797988 4879899547555797988



which will remove all of the non-numeric characters from the string.

If you need to extract the numbers in groups, as they are separated in the
string, then use this formula:

=REGEX.MID($A1,"\d+",COLUMNS($A:A))

and copy/drag across as far as required for the number of groups.

fjdslfdslflsd455646sdfds768468 455646 768468

fsdfsd4879899 fsdfdsf547555sdfds797988 4879899 547555 797988



--ron