Professor Excel
len, formula, length, excel

LEN Formula: Get the Number of Characters in Excel

You need to know how many characters does the cell contain?

space, remove, blank, cell, excel

Space Character: Remove Last Letter in Excel If It Is Blank

Does this situation sound familiar to you: You compare texts in Excel and they should be equal. But instead, Excel says the two cells are not the same. Oftentimes, there is a hidden space in the end of a text cell. Very troublesome: You can’t really see it because the blank character is at the end of the text. In this article we explore 4 methods of how to remove the last character of a text in Excel if it is a space. 

[…]