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 How do you stack 3 words in one cell

You can use alt-enter:
A word(alt-enter)A second word(alt-enter)A Third word
would look like:

A word
A second word
A Third word

And if you're using a formula:
=a1&char(10)&b1&char(10)&c1

And format the cell to wraptext


Tami Sawyer wrote:

I am trying to figure out how to put the text "monthly rental pmnts" all in
one cell so that they stack on top of each other. Any suggestions?


--

Dave Peterson