Hi all,
I have a paragraph of Chinese characters in cell A1 of sheet2 that need to be replaced with English words.
In sheet 1, column A contains Chinese words with thier corresponding English word in column B.
As this is a long table, and new words may be included frequently, nesting formula will not be feasible.
Is there anyway to do this please?
I have a paragraph of Chinese characters in cell A1 of sheet2 that need to be replaced with English words.
In sheet 1, column A contains Chinese words with thier corresponding English word in column B.
As this is a long table, and new words may be included frequently, nesting formula will not be feasible.
Is there anyway to do this please?
