Text truncates in a cell 1

[wilbur00]

Hello -

(Excel 2003/Windows XP)

I have multiple worksheets that have text on them. I want to show the text that is entered on one spreadsheet, so on the "combined" worksheet I use "=Sheet2!A1" and "=Sheet3!A1" and "=Sheet4!A1" to pull the text into different cells on Sheet1. Unfortunately some of the text is truncated. I've set up my cells to wrap text and have also set the row up as auto height to be sized relative to the text in the cell.

How can I get the text to stop truncating? Does Excel have a limit where only the first 255 characters are copied?

Thanks for your help!

 

[Tatertot45]

Found this in the Help for you. Search "Character Limits".

Column width max is 255 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

 

[wilbur00]

Thank you... I found out if both spreadsheets are open at the same time (some of my worksheets are in a different Excel file), the full text comes through to the "combined" sheet.