Dave's method in column C, works beautifully for me. Then you'd copy and use
Paste Special, Value to copy the "fixed" names back to column A if you want.

"dk" wrote:

Does not seem to be working its copies from column from column a to column c,
we would like to remove the data from column a if it appears in column c
Hi,

In C1, try something like

=SUBSTITUTE(A1,B1,"")

and copy down.

Dave

url:http://www.ureader.com/msg/10356893.aspx