Identify text in the cell and mention value in another cell

[Anantha Krishna]

Hello All,

Kindly help me for the below situation on coding.

I need to identify text in the cell from the columnA , based on that i need to mention value on the column B.

E.g:- if on the columnA have "product is on production from factory"

So for the text "production from factory"

On the columnB have to mention "production de l'usine".

Thanks in advance
Krishna

 

[vletm]

Anantha Krishna
How to guess, which part of cell value is that text You would like to identify?

 

[Anantha Krishna]

Anantha Krishna
How to guess, which part of cell value is that text You would like to identify?

Hello vletm,

Thanks for your reply, i have got the solution.