Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
PROPER FUNCTION | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Worksheet Functions | |||
PROPER function | Excel Worksheet Functions | |||
How do I use the PROPER function? | Excel Discussion (Misc queries) |