How to generate a string of random letters in Excel
The CHAR function returns a character that corresponds to the number in the character set used by your computer (ANSI for Windows). There are up to 255 different characters in the set, with the capital letters from A-Z starting at number 65. Z is 90. To generate a random letter you can use the RANDBETWEEN function:
Unclean data can cause a lot of problems in Excel. In this post I will show how you can join data from different columns with a comma between them. That’s the easy part. The problem occurs when you have empty cells in your data, like in the table below. The result of the first row looks fine, but if you look at the rows with empty cells, you get too many commas:
We often need to measure the length of a text, for example if we write a text that will appear on a website. Typically, in a web shop the product introduction text has to be of a certain length in order to fit within the frames.
Of course, the easiest way to do this is in Excel. This is extremely easy – it only takes a few seconds: