Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Character limit for a cell in Google Sheets

What is the character limit for a single cell in Google Sheets?

An answer in this forum mentioned it may be ~1 million.

like image 458
Augustine C Avatar asked Jul 11 '17 16:07

Augustine C


People also ask

What is the cell limit in Google Sheets?

We've increased the cell limit in Google Sheets from up to five million cells to up to ten million cells. This limit applies to new, existing, and imported files.

How do I add more than 255 characters in Excel?

Text values in formulas are limited to 255 characters. To create text values longer than 255 characters in a formula, use the CONCATENATE function or the concatenation operator (&).


1 Answers

While there may not have been a limit before when that forum was posted, today (July 2017) the limit is 50,000 characters. If you try to input 50,001 characters, you will get this error:

enter image description here

like image 51
Augustine C Avatar answered Oct 23 '22 11:10

Augustine C