View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default type a sentence so it extends over grids

xl95 was the last version that only held 255 characters.

xl97-xl2003 holds 32k--about 1k will show up in the worksheet unless the user
does something special.

Bruce Sinclair wrote:

In article , "Earl Kiosterud" wrote:
Donna,

Text can spill into the next cell if it's empty. And the next, etc. Look for
something
(even a space character) in the cell that's stopping it. Also, make sure that
the cell
containing the text isn't set for wrap text (Format - Cells - Alignment).


Also note that XL cells can "only" handle 255 characters. Doesn't sound like
that's your problem ... but in case it is, you can obviously split long text
across more than one cell. :)


--

Dave Peterson