MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Override the limitations of 254 char per cell

  Asked By: Sherry    Date: Sep 26    Category: MS Office    Views: 795

Anybody knows how to override the limitations of 254 characters in
every cell of Excel spreadsheets.



2 Answers Found

Answer #1    Answered By: Fuzairah Neeman     Answered On: Sep 26

The limitation applies to some procedures for putting info into excel cells.
The cells can contain far more than 254 chars.

It depends on what you are trying to do. If you try to copy a worksheet with
more than 256 chars in a cell  it will only copy the first 256 cells. To
overcome this you select all the cells in the source spreadsheet, copy them,
and paste into the target spreadsheet.

Answer #2    Answered By: Brandi Ramirez     Answered On: Sep 26

You'll need to be more specific. I can create a string of up to
32,767 characters and put it into a cell. For example:


Didn't find what you were looking for? Find more on Override the limitations of 254 char per cell Or get search suggestion and latest updates.