310 Wattle StUltimo, 2007, NSW
How the way i get NSW2007 from this text?
310 Wattle StUltimo, 2007, NSW
How the way i get NSW2007 from this text?
Hello John123,
If texts 2007 and NSW always have same length, following formula can work:
=RIGHT(RIGHT(SUBSTITUTE(B3,",",""),8),3)&LEFT(RIGHT(SUBSTITUTE(B3,",",""),8),4)
Please try and let me know.
Regards
Basilio
=RIGHT(RIGHT(SUBSTITUTE(B3,",",""),8),3) & LEFT(RIGHT(SUBSTITUTE(B3,",",""),8),4)