Find and Replace text dinamicaly in multiple rows...

[fgs]

Hello Everyone,


I have an excel sheet with three column. All columns contain simple text.


For example:


A1 = Hello, my name is John!

B1 = John

C1 = Charlie


I want to replace John with Charlie, so...


I want to find the value of B1 in A1 and replace with C1.


And of course, I have hugh file with many rows.


How can I do that in an easy way? Should I use Macro?

 

[shrivallabha]

Welcome to Chandoo.org forum.


You can try:

=SUBSTITUTE(A1,B1,C1)

 

[fgs]

Hi, thank you...


=SUBSTITUTE(B1,C1,A1) was the good solution for me! thanks!