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