Brecht
Member
- Joined
- Sep 15, 2014
- Messages
- 36
- Reaction score
- 0
- Points
- 6
- Location
- Netherlands
- Excel Version(s)
- Version 2007
Hi all,
we are translating our website (more than 5000 products) into German. Doing all the translations by hand would be an enormous amount of work, that is why we thought of using "building blocks", where an English phrase would be substituted by its German equivalent.
So if you have the sentence
"This product has a height of 30 cm and a width of 20 cm",
"This product has a height of" would be one building block, and "and a width of" would be another.
I am now searching for an Excel formula that automatically substitutes these building blocks with their German equivalents. So what I need is a formula that does the following:
"If any cell in column A contains the same text as cell B1, this text in column A should be substituted by the text as in cell C1."
But, of course, the cells in A do not match the text of B1 100% as they consist of more building blocks than 1.
I have been looking at the IF( function, but I am not sure if this will work.
Could anyone help me out? And please also tell me if it is not possible at all.
Thanks!
we are translating our website (more than 5000 products) into German. Doing all the translations by hand would be an enormous amount of work, that is why we thought of using "building blocks", where an English phrase would be substituted by its German equivalent.
So if you have the sentence
"This product has a height of 30 cm and a width of 20 cm",
"This product has a height of" would be one building block, and "and a width of" would be another.
I am now searching for an Excel formula that automatically substitutes these building blocks with their German equivalents. So what I need is a formula that does the following:
"If any cell in column A contains the same text as cell B1, this text in column A should be substituted by the text as in cell C1."
But, of course, the cells in A do not match the text of B1 100% as they consist of more building blocks than 1.
I have been looking at the IF( function, but I am not sure if this will work.
Could anyone help me out? And please also tell me if it is not possible at all.
Thanks!