=int

[moone009]

Is there a function like =int but with text? I use =int to make sure all values in a column are integers and then filter the #VALUE!

Is there any such function that I can do with text columns when it will raise the #VALUE! error if something in the row is not text such as {-,.,1,2,3,4,5,6,7,8,9,0,%} etc...

 

[texasalynn]

=istext(a1)
this will give you a true/false and then you can filter

 

[schielrn]

A -, . and % would be considered text. This is one way to test if something is text:

Excel Workbook
	J	K
24	#VALUE!	.
25	Is Number	2
26	#VALUE!	t
Sheet15

Cell Formulas
Range	Formula
J24	=IF(NOT(ISNUMBER(VALUE(K24))),""+2,"Is Number")

You can also use istext(), but if a number is formatted as text it will return that it is text.



Hope that helps.

 

[Scott Huish]

Why the NOT?

=IF(ISNUMBER(K24+0),"Is Number","+2")

 

[schielrn]

Why the NOT?

=IF(ISNUMBER(K24+0),"Is Number","+2")

NOT really sure why I did it that way.