Let’s say you are preparing Excel translation files for Translators, and the same files shall be used by Web Developers to implement the new languages in your web site.
First I will show you how to make Excel warn Translators if they write a too long word or sentence for a menu item etc. This can also involve Web Designers to specify in the Excel sheet how much space each interface element has. You will also later learn how you easily can get JSON strings from Excel columns to provide Web Developers with an easy tool.
In below video I show you how to count the number of characters in an MS Excel cell, and how to highlight the cell if the number of characters exceed the maximum specified.
In the second video I show you how the formula and JSON string will look like:
And in the third video I explain the Excel to JSON formula in detail:
My course outline: http://gabriel.nu/tutorials/My Skillshare Class Outline.docx
In the column G, row 4, we will write our formula to convert/(combine) two columns (A+D) into JSON format and copy that formula to all rows below in column G.