Help in Excel in a cell there are words and numbers but in the next cell i want only the numbers ?

Question

Help in Excel in a cell there are words and numbers but in the next cell i want only the numbers ?

Answer 1

You can write a custom VBA function to do that.

Ready-made functions do not provide such capability. But it should 15 mins to do that in VBA.

Go in a for loop, take each character, check whether it is numeric and add it onto another string which is eventually returned from the function.

Answer 2

where are the numbers? at the beginning or at last or in the mid?
Use appropriate function to get them

Example: Let
2007YAHOO
in A1

=LEFT(A1,4)

or
YAHOO2007
=RIGHT(A1,4)