locked
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.

     

    Thanks

    Wednesday, October 24, 2007 4:15 AM

Answers

All replies