I used proper() on a list of company names and addresses. the company that
included a ('s) got changed to ('S). The direction in the addresses got
changed from (SW) to (Sw). I tried to find and replace but the find did not
recognise ('s) or (Sw). I even setup another column and used copy and paste
special values to permentely change the data from that was changed with
Proper().
Bookmarks