How do I replace ('S) with ('s) within an excel list of company na

Giganews Newsgroups
Subject: How do I replace ('S) with ('s) within an excel list of company na
Posted by:  John1521
Date: Mon, 5 Jun 2006

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().

Replies