How to Increase Character Limit in Excel Cell (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes, we set character limits in Excel which we need to increase later. In this article, I will show you how to increase character limit in Excel cell.


Download Practice Workbook

Download this practice workbook and practice.


2 Easy Methods to Increase Character Limit in Excel Cell

This article will cover 2 easy methods to increase the character limit in the cells of Excel. This is the dataset for today’s article. We have some people with their cell phone numbers. The numbers have a fixed character limit of 5 digits. That means you cannot input a cell number that has more than 5 digits. I will change that and increase the limit.

how to increase character limit in excel cell


1. Increase Character Limit to a Fixed Length

Well, you have already gone through the dataset. Suppose the number of users of the mobile operator has increased lately. So, now, the operator has to add 1 digit to accommodate the increased number of customers. But due to the character limit, you cannot increase the character length.

Let’s see how you can increase the limit.

Steps:

  • First of all, select the dataset.
  • Then, go to the Data
  • After that, select Data Validation.

Data Validation to increase character limit in excel cell

  • After that, the Data Validation box will appear.
  • Then, allow Text Length as the data type.

  • Then, select the character length 6.
  • After that, select OK.

Data Validation to increase character limit in excel cell

  • Now, you can have a number of 6

how to increase character limit in excel cell

Read More: How to Set Limit in Excel Cell (5 Simple Ways)


2. Expand Character Limit Beyond a Fixed Length

Now, there is a limitation to the previous method. You can input a number that has only 6 digits, not more or less than that.

That’s why I am going to show another method that will give you more flexibility. This method also requires Data Validation criteria.

Steps:

  • Bring up the Data Validation box like the previous method.
  • Then, set the character length as greater than or equal to 6.
  • After that, select OK.

  • Then, you can add numbers with digits more than 6.

Read More: How to Set Limit for Visible Area in Excel (3 Ways)


Things to Remember

  • You need to use the Data Validation feature here.

Conclusion

In this article, I have explained how you can increase character limit in Excel cell. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit ExcelDemy for more useful articles like this.


Related Articles

Tags:

Akib Bin Rashid

Akib Bin Rashid

Hi, this is MD Akib Bin Rashid. I completed my BSc in Engineering back in 2019. After that, I did an MBA. Then, I joined as an Excel and VBA Content Developer at SOFTEKO Digital. Being passionate about data analytics and finance, I will try to assist you with Excel

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo