Excel Filter: Search the contents of one cell for the contents of another cell, then replace with the contents of yet another cell? Is it possible?
February 24, 2010 3:42 PM Subscribe
I need to search the text in column A for the text in column B, replace it with the text in column C, and return the new complete string to column D. I've Googled. I've read. I've cried. Can you please help me?
posted by Salient to Computers & Internet (5 answers total) 11 users marked this as a favorite
I know I'm going to kick myself for not knowing this (and for failing at the Googles)...
The sheet is set up as shown below. I need to parse A for B and replace the found string with C, and return the end result to a new column, D. Then I need to apply it to the other 5000 records in the sheet.
----Column A----------Column B----------Column C------Column D
Foo Foo2 Foo3-----------Foo2--------------Foo4--------Foo Foo4 Foo3
I'm really hoping that this is endlessly complicated, so as to save me some personal embarrassment.
Thanks very much for taking the time to look!