Search cell A1 for text string from B1, replace with text string from C1

[portokie]

Example:
A1 = Mickey Mantle Baseball Cards
B1 = Mickey Mantle
C1 = Mantle, Mickey


Desired output:
D1 = Mantle, Mickey Baseball Cards

[63falcondude]

Try this in D1:

=SUBSTITUTE(A1,B1,C1)

[Richard Buttrey]

Hi,

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

That said and for the example given

D1:

Please Login or Register  to view this content.

[portokie]

Hi,

This is clearly a much simplified example and probably doesn't represent the size of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

That said and for the example given

D1:

Please Login or Register  to view this content.

This worked perfectly! Thank you so much!

[Richard Buttrey]

My pleasure and thanks for the rep.