How to find whether a cell contain letter a,b,....,z

[kelvin-lkh]

Dear all Excel Pro,

I remember there is a formula to identify whether a cell contain letter a to z but I can't locate the post. Can you please advise where is the post I can refer to the formula.

Thanks.

 

[bosco_yip]

Try,

In B1, array formula ("Ctrl+Shift+Enter") copied down :

=OR(CODE(MID(UPPER(A1),ROW($1:$99),1)&0)>64)

 

[Peter Bartholomew]

This reverses the @bosco_yip formula by generating a text alphabet and searching the target for alpha characters. The Lambda function and MAP allow the target terms to be evaluated as a single array. This may not be of any special value, but it would, for example, allow the list to be filtered.

= LET(
  alpha,      CHAR(SEQUENCE(26,,65)),
  hasAlphaλ,  LAMBDA(t, OR(ISNUMBER(SEARCH(alpha,t)))),
  MAP(target, hasAlphaλ))