Cell contents get cut off when pasting

[Annabelle4876]

I am trying to combine 3 tables together that are all in separate worksheets.
They are all simple, no formulas, macros or anything. The problem is that I
have some cells that contain a lot of text (product descriptions). When I
paste the table in, it only keeps the first 255 characters of each, and
deletes the rest.

Is there any way to fix this? I am sure that it is simple, but I am at a
loss. This have never happened to me. Thank you.

 

[training]

It's not that there is a way to fix this, such a thing is a limitation
of the actual program itself. 255 characters is all you will ever be
able to get into one cell.

A somewhat limited suggestion then is to include another cell to hold
the "cut off" text".

You could for instance make a cell reference to the first 255
characters (Using the LEFT function) and then referring to the
remainder of the characters using a RIGHT text function. It might
increase your process time but alas, I know of no other way of getting
around your problem but wouldn't be surprized to here of someone else
here with such an insight.

HTH

-Imonit

 

[Gord Dibben]

Annabelle

The only way I can replicate your problem is when I copy a cell with mucho text
from a workbook into another workbook which is running in a separate instance of
Excel.

Then the 255 limit comes into effect.

Within the same instance of Excel the cell limits are 32,767 charaters in a
cell, although only 1024 will show in the cell.............all will show in the
formula bar.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Forgot to mention......close one instance of Excel and run both workbooks in a
single instance.


Gord

 

[Gord Dibben]

Not true.

See my reply to Annabelle and/or check "specifications" in Excel help.


Gord Dibben MS Excel MVP

 

[jtalboy]

I am using the excel file as a source document for a publisher catalog merge.
Any suggestions on how to make this work? Same problem, cutting off long
descriptions.

 

[Gord Dibben]

I don't work with Publisher so have no suggestions for you.


Gord