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.

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

On May 21, 1:38*pm, Annabelle4876
wrote:
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.

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


On Wed, 21 May 2008 10:38:00 -0700, Annabelle4876
wrote:

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.

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


Gord

On Wed, 21 May 2008 14:42:52 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Wed, 21 May 2008 10:38:00 -0700, Annabelle4876
wrote:

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.

Not true.

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


Gord Dibben MS Excel MVP

On Wed, 21 May 2008 11:45:58 -0700 (PDT), wrote:

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.

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" wrote:

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


Gord

On Wed, 21 May 2008 14:42:52 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Wed, 21 May 2008 10:38:00 -0700, Annabelle4876
wrote:

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.

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


Gord

On Tue, 12 Aug 2008 12:35:01 -0700, jtalboy
wrote:

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" wrote:

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


Gord

On Wed, 21 May 2008 14:42:52 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


On Wed, 21 May 2008 10:38:00 -0700, Annabelle4876
wrote:

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.