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
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