Limit # of characters in a cell
Excel Tip #017 Limit # of characters in a cell We would have come across situations where we want to restrict the end user from typing lengthy sentence in a cell which would then get itself autofit (or) sometimes we don't see the entire comment if the adjacent cell has data in it. To overcome this situation, we can limit the end user to have only certain number of characters that can be typed in a cell. In our example, the sales rep address should not be greater than 20. So we are limiting the range of cells to be greater than (or) equal to 20. For ease, I have created a column name length which displays the length of the address for each sales rep. Example - Limit # of characters in a cell You can see that the address of the sales rep Walker (in cell B10) is greater than 20. So we are going to give a constraint. Here's how you can limit the number of (text) characters that can be entered in a range of cells: Select the range of cells you want to limit to ...