Hello

I am trying to extract text from the following text string example. I want to return from two places after the comma, to 2 places before the N. The comma is constant, from the N in NSW to the end will always be the same number of spaces but often different text (could be NSW 2795 or NSW 2800 or Vic 3454) the other text will vary. So from this example, I want NEW YORK. The result is not on 'stock register list'! but another sheet

28 CURUMBIN PLACE, NEW YORK NSW 2000

I have been working with
=MID('stock register list'!J2,SEARCH(",",'stock register list'!J2,4)+2,RIGHT('stock register list'!J2,9))
but I just can't get it. Any suggestions?

Cheers