Hi,
I previously had some help from Istvan extracting the %'s of fabrics from certain cells. Now I would need to translate the different fabric types, just the names not the %'s of course.
So I have the English names as starting point. Now I need to translate them to Dutch and French (more in the future, but lets start with this)
but again, I only need to replace the fabric name so the x-amount of % needs to stay in front. I've taken a random example below.
Column AN Column AO Column AP
<tbody>
</tbody>
<tbody>
</tbody>etc.........
In another file, I have the English names in Column A, French in Column B, Dutch in Column C.
<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>
</tbody>
Is there a formula I can use for this? I'm guessing any space between a two (or more) component fabric name will present a problem? So I would have to connect it with a - or something again?
Many thanks in advance once again for any support!
Regards,
Wouter
I previously had some help from Istvan extracting the %'s of fabrics from certain cells. Now I would need to translate the different fabric types, just the names not the %'s of course.
So I have the English names as starting point. Now I need to translate them to Dutch and French (more in the future, but lets start with this)
but again, I only need to replace the fabric name so the x-amount of % needs to stay in front. I've taken a random example below.
Column AN Column AO Column AP
Material Description EN | Material Description FR | Material Description NL |
<tbody>
</tbody>
40% Acrylic, 33% Polyester, 27% Wool |
<tbody>
</tbody>
In another file, I have the English names in Column A, French in Column B, Dutch in Column C.
A | B | C |
Eng | Fr | NL |
Acrylic | Acrylique | Acryl |
Polyester | Polyester | Polyester |
Wool | Laine | Wol |
<colgroup><col width="72" span="3" style="width:54pt"> </colgroup><tbody>
</tbody>
Is there a formula I can use for this? I'm guessing any space between a two (or more) component fabric name will present a problem? So I would have to connect it with a - or something again?
Many thanks in advance once again for any support!
Regards,
Wouter
Last edited: