View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Combining cells with separater

Hello Gord,

...
Note: *you most likely will not see all the characters displayed in the cell
due to Excel's 1024 character display limit.
...


1024 characters?

http://www.xlam.ch/xlimits/ shows [Zeichen = characters] per cell:

Excel 2.x: 255 Zeichen
Excel 3.0: 255 Zeichen
Excel 4.0: 255 Zeichen
Excel 5.0: 255 Zeichen
Excel 7.0/95: 255 Zeichen
Excel 97: 32'000 Zeichen = 32'767 Zeichen
Excel 2000: 32'767 Zeichen
Excel 2002: 32'767 Zeichen
Excel 2003: 32'767 Zeichen
Excel 2007: 32'767 Zeichen

Regards,
Bernd