My sheet contains three columns. Out of them, one column contains English words, second column contains some language words, which are translated from the first column and the third column contains the Language Name of the second column. Here, my question is how to know whether second column words are exactly converted from the first column. Thanks in advance.
It is not really clear what you mean under ‘are exactly converted from’. Explain.
HI Gabix,
Please ignore that if you do not understand.
Say for example column A contains some english sentences
- 1st cell contains: This is my pen.
- 2nd cell contains: Be the first one to answer this question.
- 3rd cell contains: Rename the sheet.
column B contains Spanish sentences (Translation of the column A sentences)
- 1st cell contains: este es mi pen.
- 2nd cell contains: Sé el primero en responder a esta pregunta.
- 3rd cell contains: Cambiar the nombre de la hoja.
If you observe my last comment you will notice the word “pen” (column B, 1st cell) is not translated to Spanish, column B, 2nd cell sentence totally converted to Spanish. And again if you observe column B, 3rd cell sentence, in that, the word “the” is also not converted to Spanish.
Here my question is…how to find the words that are not converted into Spanish language?
You should better share a sample file.
Did you get my point or still need sample file?
Please let me how can I attach sample file ?
It is always a good idea to attach a sample file. I understand what you try to achieve, but I don’t understand what you work with, i. e. I don’t see your file layout.
I think, you can upload an attachment by editing your original answer, but there are some limitations. Better use a file sharing service such as DropBox.