SUBSTITUTE – XLf(x)s

Count how many times letter found

Posted on March 3, 2017 by ANmar

Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter (or any string) into a cell. So the main formula doing that is … =LEN(I12)-LEN(SUBSTITUTE(I12,”o”,””)) Of course, this assumes you are looking to find how many the letter “O” is […]

Multiple lines in cell using functions

Posted on December 2, 2016February 21, 2017 by ANmar

You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to cell below (we can change that behavior by the way, but that is another post). And you could have already know that if you want to have multiple lines inside […]