Excel Formula To Check If All Characters Are Text Non-Numeric

[Admin]

Hi Nitin,

Welcome to ExcelFox !!!

one way..

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))> LEN(A1)

[NITIN SHETTY]

Hi,


Thanks for your help it does work for numbers for Ex ABCD43D

But not in case of special characters For Ex ABCD#$D

Please help.


Thanks

NItin shetty