wondering if there is a way to remove text from one cell that is already in the neighboring cell RRS feed

  • Question


    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.



    Wednesday, October 24, 2007 4:15 AM


All replies