This is for editing HMI texts en masse in Excel.
My problem is that in my HMI texts, some are in multiple lines, even if they are single texts. The HMI texts can be exported from TIA to Excel and imported to TIA from Excel.
My problem is that when you view the individual rows in Excel, the carriage-return is 'hidden' so to speak. Only if you select a text, will it be shown as multilines.
When browsing the texts they are displayed like this:
Line1Line2Line3
when a text is selected it displays like this:
Line1
Line2
Line3
It is particularly a problem when we send the texts to be translated by an external translator. They almost always miss that the texts are multi-line, so we have to modify the texts after we get them back from the translator, and that can be a big job.
In Word there is an option to 'display non-printable characters' but I cannot find something similar in Excel ..
Any ideas ?
My problem is that in my HMI texts, some are in multiple lines, even if they are single texts. The HMI texts can be exported from TIA to Excel and imported to TIA from Excel.
My problem is that when you view the individual rows in Excel, the carriage-return is 'hidden' so to speak. Only if you select a text, will it be shown as multilines.
When browsing the texts they are displayed like this:
Line1Line2Line3
when a text is selected it displays like this:
Line1
Line2
Line3
It is particularly a problem when we send the texts to be translated by an external translator. They almost always miss that the texts are multi-line, so we have to modify the texts after we get them back from the translator, and that can be a big job.
In Word there is an option to 'display non-printable characters' but I cannot find something similar in Excel ..
Any ideas ?