i have a list of 1000+ items and i was wondering if there was a way to remove certain items from a cell while leaving others?
for instance: Columns A & B below
A B
xx xxXX
x xXXX
xxx xxxX
I need to remove the lower case x's from column B because they are already in column A. Of course the x's stand for words and the info in column A & B were once identical except some info was removed from A and what is in A needs to be removed from B. I would like to know if there is a way to do this other than manually going through each and every cell in the column.
Thanks