Copying sheets

[SUMO]

when i copy sheets in a workbook, its telling me that i have more the 255
character in some cells and it will only copy 255 character, is there anyway
to change the number of characters.

 

[icestationzbra]

sometimes the best way to find answers on this forum is by searching th
database for similar posts and replies thereof.

http://www.excelforum.com/showthread.php?threadid=251163&highlight=cell+limi

 

[Gord Dibben]

SUMO

You don't say which version of Excel or platform but if using Excel 98 for Mac
check here..........

http://support.microsoft.com/default.aspx?scid=kb;en-us;183019

This URL for more general info on the 255 char limit and truncation.

http://support.microsoft.com/search/default.aspx?Query=excel+255+characters

Gord Dibben Excel MVP