On Thu, 17 Dec 2009 16:28:01 -0800, Mustang
wrote:

Hi Ron,

We are NZ based so dont have the 2 letter state abbreviation.

Thanks

OK, if all you have to deal with is the Po issue, and if your PO is always
preceded and followed by <space, then:

=SUBSTITUTE(PROPER(A1)," Po "," PO ")

should work.

It works whether or not PO is in the original string.
--ron