Thread: Check if a cell contains a number and text as opposed to just text

Hey all,

I have two kinds of content in cells, either a business name or address:

'CHARLES R TUTWILER AND ASSOCIATES INC
'127 GRAND AVENUE

The address will contain a number whereas a business name shouldn't. Hence, I am only trying to target the businesses not addresses. So the only way I see to do this is to check if the cell contains a number at the second index position. If so, then it must be address. Problem is the ISTEXT function returns true even when I try to determine whether the second character is text, even though it isn't, as illustrated in attachment.

Thanks for response.

Thanks for response.

I ultimately got it working with this:

=REGEX.COMP(A2,"[1-9]")