this is a tough one

[thexfactor44]

I have a situation that has been killing me..
I have two columns, we'll say column A and column B. Column A contains names and Column B contains several names, sometimes including the same name that is in column A on the same row. I need to come up with a way to remove the name in Column B that is redundant to Colum A on the same row...while leaving the rest of Column B's contents there. I will be amazed if there is a way..I have been killing myself over this one.

Thanks all.

[Damon Ostrander]

Hi thexfactor,

This is not hard to do with a macro. But you didn't mention whether you have delimiters that need to be removed at the same time. For example, if you have in the B column

Fred, Joan, Bill, Mary

And you want to remove Bill so that the list becomes

Fred, Joan, Mary

then the macro has to remove Bill and the preceding or following comma and space (depending on where it is in the list).

If the delimiters are not consistent (e.g., sometimes a space, sometimes a comma or hyphen, sometimes multiple spaces, then the approach would be a bit different.

Provide this information and I'm sure you'll receive a quick solution.

[thexfactor44]

kill this thread..my apologies..i will repost a new thread noting the new method.