MID and FIND

[LucasP40]

I need your help. Using just MID and FIND function I need to retrieve just post code e.g 2007 from:

310 Wattle StUltimo, 2007, NSW

Thanks 

Lukasz 

[#2]

how about
=mid(a1, find(",",a1)+1, find(",",a1,find(",",a1)+1)-find(",",a1)-1)
but using the new formulas would be easier:
=INDEX(TEXTSPLIT(A1,","),2)

[#3]

@mtarler 

thanks for quick reply.

But I need to use only 1 MID and 1 FIND function to get this result. My closest result is “, 2007” with “=MID(A1,FIND(“, “,A1),6” but can’t get rid off “, “ before 2007.

Any thoughts? 
Thanks in advance 

[#4 · Accepted solution]

@LucasP40 

But I need to use only 1 MID and 1 FIND function to get this result ??? What is/are your constraint(s)?

Based on your single example, this could be:

=MID(A1, FIND(", ", A1)+2, 4)

[#5]

@L z. 

Amazing, this solved my problem, finally I will sleep well :)

Thanks all for your support 

[#6]

@LucasP40 

You were very close

At the bottom of each reply you get there's a way to mark a solution - something that helps those who search. @mtarler was kind enough to do it on your behalf. Don't miss it next time(s)..., Please

[#7]

will do, thanks @mtarler