Excel 2007 - Total number of characters that a cell can contain = 32,767
characters
--
If this post helps click Yes
---------------
Peggy Shepard


"JAH" wrote:

I get information (text) sent to me in an excel workbook from a coworker that
I have to copy and paste into another excel file to create a database for use
with pivot tables, etc.
But when I paste info into new workbook, not all the information is there.
I've been double clicking each incomplete cell, copying and then double
clicking the cell in new worksheet and pasting. There's got to be a better
way. Can anyone help me?