Number identification

How about

Please Login or Register  to view this content.

Thank you for this code, i noticed you had but USA into code. My bad but I have got all sorts of aadresses in Europa, China... .
Can you make somekind on universal code?
Thanks.

Originally Posted by jindon

How about

Please Login or Register  to view this content.

Then you need to show me some possible sample data with the result that you want, otherwise that too vague.

Originally Posted by jindon

Then you need to show me some possible sample data with the result that you want, otherwise that too vague.

Here you go:
Teollisuustie, 60100 SEINÄJOKI
Vaskikatu 20380 TURKU
Vehmaantie 7, 33470 YLÖJÄRVI
Kiteentie 7, 82500 KITEE
Pansiankatu 9, 38700 KANKAANPÄÄ
London SW11 3NA, 98514 UK
Hevoshaankatu 3, 28600 PORI
New York 13416 USA
Armilankatu 31, 53100 LAPPEENRANTA
Kaakelikaari 2 A 01720 VANTAA
Hongkong 98503, China
Myllymäenkatu 6, 53550 LAPPEENRANTA
Lempääläntie 22, 33840 TAMPERE

First, you need to follow the rule about code tag, so you must edit your first post.
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Originally Posted by dilipandey

Hi HelpExc,

Suggest you to follow forum rules and put code tags in your code.. thanks.

http://www.excelforum.com/forum-rule...rum-rules.html


Regards,
DILIPandey

<click on below 'star' if this helps>

Done, thank you for reminding me.

Originally Posted by jindon

First, you need to follow the rule about code tag, so you must edit your first post.
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Thanks for that.

This evaluates if the last appear block of number has 5 digits or not.

Please Login or Register  to view this content.