You need to know how many characters does the cell contain?
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… Continue reading Space Character: Remove Last Letter in Excel If It Is Blank