Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dajana
 
Posts: n/a
Default Max number if characters in a merged cell

Maximum number of characters in my merged cell is 255. I thought that the
maximum number of characters in a cell is 1034. How can I fix this problem.

thanks
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

The maximum number of characters in any cell is about 32k.

The maximum number of characters you can see in the cell is about 1024 unless
you add alt-enters every 80-100 characters (to force new lines within the cell).

But that 255 number seems suspicious.

Does your merged cell have a formula that points to a closed workbook? If yes,
then that's the way excel works.

If you open the other workbook, you'll see all the characters.

You may have to adjust the rowheight manually, though.

Dajana wrote:

Maximum number of characters in my merged cell is 255. I thought that the
maximum number of characters in a cell is 1034. How can I fix this problem.

thanks


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fill or truncate to a certain number of characters in a cell Jan Buckley Excel Worksheet Functions 1 March 16th 05 04:46 PM
How do you count number of characters in a single cell Joe Excel Worksheet Functions 1 February 18th 05 10:08 PM
How do you count number of characters in a single cell Joe Excel Worksheet Functions 1 February 18th 05 09:33 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 08:18 AM
Defining a number in a cell by text then subtracting it by the tex Crowraine Excel Worksheet Functions 1 December 16th 04 08:49 AM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"