Long text in Excel

  Timoj 09:07 06 Aug 2003

Is there any way to write more than 256 characters in one cell? I would need to have a comment box in an Excel spreadsheet with a possibility to write relatively long comments that are visible also on the printed page. I tried to do it by merging several cells to create a box for the comments, but if the comment is longer than 256 characters, only ####### is shown.

If I insert a text box, it is not possible to move with tab from other cells to the comment box. Is text box the only option?

  VoG II 09:23 06 Aug 2003

A cell can hold up to 32,767 characters but Excel will only display 1024 characters in a cell.

Make sure that the cell is formatted as Text.

  Timoj 11:06 06 Aug 2003

Thank you for your answer, but my Excel XP only displays 256 characters and the cell is formatted as Text.

Any other ideas?

  VoG II 11:19 06 Aug 2003

According to click here you should be able to see approx. 1024 characters so I'm not sure why you only see 256.

  Megatyte 12:09 06 Aug 2003

I've just tried this and it works. Format cells and choose Custom. In the Type box enter "x"(including the quotes).

Format as text seems a bit hit and miss. I've no idea why but, pasting a text document into Excel gives 1024 but entering direct gave me ######.


  xania 13:30 06 Aug 2003

To insert a line feed within a cell, you need to hold down the <Alt> key when you prress the <enter> key.

  Timoj 14:38 06 Aug 2003

Thank you Megatyte. I tried formatting as x without quotes and even it works. Sometimes I have a feeling that MS Office programmes really believe they are more clever than their users! Especially Word.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Moto G6 Play Review: First Look

iPad 9.7in (2018) review

Comment utiliser Live Photos ?