Issue with PROPER function
Brilliant, the formula works perfectly!
Many thanks
"Jacob Skaria" wrote:
Once you apply PROPER() function. Copy the cellsright
clickPasteSpecialValues and paste it to the same location to convert the
formulas to values. Then select the cells
Hit Ctrl+H to Find Replace....check Match Case
Find
'Po ' (P0 followed by a space)
Replace with
'PO ' (PO followed by a space)
If PO is within the text then try find ' Po ' and replace with ' PO '
OR try the below formula
=IF(ISNUMBER(FIND(" PO "," " & A1)),TRIM(REPLACE(" " & PROPER(A1),
FIND(" Po "," " &PROPER(A1)),4," PO ")),PROPER(A1))
--
Jacob
"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
|