Is there a way to find out whether theres a number in a cell??

  • Thread starter Thread starter elaine216
  • Start date Start date
E

elaine216

Hi,

Is there a worksheet function that could help finding out whether
theres a number in a cell, within a string etc??

Thanks.

Elaine.
 
how about if my cell contains apple123?? it doesnt seem that the
isnumber(), istext() function work....
 
with
A1 containing a number, alphanumeric, text, or blank

Try this:
=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))<=LEN(A1)

That formula returns TRUE if there are any numbers in A1's value

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Here's a shorter alternative to the formula I posted

=SUM(--ISNUMBER(SEARCH({0,1,2,3,4,5,6,7,8,9},A1)))>0

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Using a helper column with the entire column copied over to it, there is a
feature in the ASAP Utilities that will delete all alpha characters, leaving
only the numbers........ASAP Utilities is a free add-in available at
www.asap_utilities.com

Vaya con Dios,
Chuck, CABGx3
 
Back
Top