View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mustang Mustang is offline
external usenet poster
 
Posts: 37
Default Issue with PROPER function

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