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

[TABLE="width: 500"]
<tbody>[TR]
[TD]ZETLAND NSW 2017[/TD]
[TD]true[/TD]
[/TR]
[TR]
[TD]YOUNG NSW 2594[/TD]
[TD]true[/TD]
[/TR]
[TR]
[TD]YEPPOON QLD 4703[/TD]
[TD]true[/TD]
[/TR]
[TR]
[TD]WOOROLOO WA 6558[/TD]
[TD]true[/TD]
[/TR]
[TR]
[TD]1 Kirinari Street[/TD]
[TD]false[/TD]
[/TR]
[TR]
[TD]11 London Circuit[/TD]
[TD]false[/TD]
[/TR]
</tbody>[/TABLE]

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?