256 char string size limit

  • Thread starter Thread starter jlbyrd44
  • Start date Start date
J

jlbyrd44

I am trying to bring data from closed workbooks into an open workbook.
This has worked fine for most cells, just hit "=" and click on the cel
I want to transfer from. I do have some cells that are long text cell
and need to stay together as one cell. When I do the same thing wit
them, only the first 256 characters show up in the copied cell. I
there a way I can get around this limit and make all the text display?

Jo
 
The maximum width of a cell is 256 characters see
Specification Limits in Help. Please look at this
if you are not familiar with "Specification Limits".

To see all of the characters you can use
Format, Cells, Alignment, Wrap Text

When you enter data manually and use Alt+Enter
to create a new line within a cell you get an automatic
Wrap text.

There is also a limit of 1,024 character that can display in
a cell, but by using some of your own Alt+Enter you can get
around that somewhat.
 
This is the way excel works.

You may want to go to the original cell and break it up into pieces. Then
retrieve each piece into different cells.

You could build a formula that retrieves it in a piecewise manner, but remember
that excel's formulas are limited to 1004 characters (when in R1C1 mode).

And with closed workbooks, this can limit your formula a whole heckava lot.
 
Back
Top