SumProduct to Count Non-Printable Characters below Code(32)

[SteveT]

Hi All,


Luke M gave me a better and working formula to count quotes used in a range


=SUMPRODUCT((ISNUMBER(FIND("""",A1:A4)))*ROW(A1:A4))


Is there anyway to make this look for all special characters below Char(32) without VBA?


Basically looking to see and report if the data that a client wants to upload into a database has any non-allowed characters.

 

[xld]

You would need VBA for that, and you could maybe use regular expressions to check for ASC(<32).


But beware ...

Some people, when confronted with a problem, think "I know, I'll use regular expressions." Now they have two problems. ~~ Jamie Zawinski

 

[SteveT]

Thanks Trying to keep format in the style that most organizations will not block. *.xls.