Find and replace Lower case values with upper case values

Hello!

In Column A I have a string a text. Within that text is a value that is in lower case. In column B I have the lower case value that is in column A but it is in all Caps.

Is there a formula to have excel look within column A for the value in column B and replace the lower case value for the upper case value?

For Example - Column A has "chlorine taste reduction cartridge swc9135-c 18" and Column B has "SWC9135-C." I want excel to replace the lower case "swc9135-c 18" in Column A for the "SWC9135-C" in column B. I want to do this multiple times with different values.

I've attached what I have (Before) and what I would like it to look like (After)

You could use this formula in C2:

=SUBSTITUTE(SUBSTITUTE(A2,LOWER(B2),"$$$$"),"$$$$",B2)

then copy down.

Hope this helps.

Pete

Pete, this is EXACTLY what I was looking for thanks so much!!!