Issue with PROPER function
Hi Ron,
We are NZ based so dont have the 2 letter state abbreviation.
Thanks
"Ron Rosenfeld" wrote:
On Wed, 16 Dec 2009 17:53:02 -0800, Mustang
wrote:
Hi there,
I have the following problem:
I am attempting to clean up some addresses using the PROPER function. This
works really well until I come to PO Box numbers.
My problem is that this makes PO Po.
I also have entries such as P O
Any suggestions on how I can do the following:
Make the rest of the address proper and not the PO part and also cater for
keeping P O as is.
Thanks
How are you handling 2-letter state abbreviations?
--ron
.
|