Replace Non English Characters to English Text

SHrenik

New Member
I have an excel which contains 2 columns in excel
Column A: Non English Chars ( which has around 7-8 rows which contains non english chars)
Column B: English Chars (For Ex, a, b, c etc)

Input Text: A & B Associates IX (Lux) ó í

I need to write a logic where my input text should compare the string with Column A in excel and then replace it with the chars in Column b

Excel Columns:
Column A Column B
í i
ó o

Can somebody please help
 
Top