Deosnt End with 4 DIGIT Number

[Blessy Clara]

Hi ,

I have a column of address . I want to sort out the complete and incomplete address

Example -

Complete address ends with 4 Digit Number as this
Incomplete doesnt end with 4 digits

ZETLAND NSW 2017	true
YOUNG NSW 2594	true
YEPPOON QLD 4703	true
WOOROLOO WA 6558	true
1 Kirinari Street	false
11 London Circuit	false

<tbody>
</tbody>

Thanks in advance

 

[Sunny Kow]

try this
ISNUMBER(RIGHT(A1,4)+0)

 

[Aladin Akyurek]

Perhaps adding a space check, we would have...

=ISNUMBER(RIGHT(A1,5)+0)

 

[Sunny Kow]

Then perhaps ISNUMBER(RIGHT(TRIM(A1),4)+0) to get rid of any unwanted spaces

 

[Blessy Clara]

Hi Sunny Kow and Aladin Akyurek

Thank you very much for your time and the formula - yeah this was very helpful

 

[István Hirsch]

Hi Sunny Kow and Aladin Akyurek

Thank you very much for your time and the formula - yeah this was very helpful

What about endings like 20e7 or 1aug?

 

[Aladin Akyurek]

Hi Sunny Kow and Aladin Akyurek

Thank you very much for your time and the formula - yeah this was very helpful

You are welcome. Thanks for the update.

 

[Aladin Akyurek]

What about endings like 20e7 or 1aug?

The input is apparently an address specification, not any input for which endless qualifications are needed.

 

[István Hirsch]

Does this end with 4 digits: 20172?