0-9 and a-z in functions

B

Bob

Hi
I am working with a spreadsheet and would like to know if there is a
function to pick values from a spreadsheet into another spreadsheet when the
values are only 0-9 and make everything else to a blank or 0.


Thanks
 
B

Bernard Liengme

=IF(AND(Sheet1!A1>0,Sheet1!A1<10),Sheet1!A1,0)
if you want a-z also, does case (Uppercase/lowercase) matter?
 
C

CLR

Put this in A1 of Sheet2

=IF(AND(Sheet1!A1>=0,Sheet1!A1<=9),Sheet1!A1,"")

and copy down

Vaya con Dios,
Chuck, CABGx3
 
Top