Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 1st 10, 09:57 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1
Default How do you stack 3 words in one cell

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?



  #2   Report Post  
Old June 1st 10, 10:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 376
Default How do you stack 3 words in one cell

Hi
Format the cell textWrapped
Then use Alt+Enter after each value where you want to start a new line

--
-------
Regards
Roger Govier

"Tami Sawyer" <Tami wrote in message
...
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?



__________ Information from ESET Smart Security, version of virus
signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5164 (20100601) __________

The message was checked by ESET Smart Security.

http://www.eset.com



  #3   Report Post  
Old June 1st 10, 10:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2010
Posts: 83
Default How do you stack 3 words in one cell

On Tue, 1 Jun 2010 13:57:01 -0700, Tami Sawyer <Tami
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?


Push ALT+ENTER wherever you want a new line

Hope this helps / Lars-Åke
  #4   Report Post  
Old June 1st 10, 10:23 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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


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
Swapping two words in a cell and placing them in another cell Christie Excel Worksheet Functions 1 February 12th 09 12:42 AM
How to line break in one cell via a formula to stack cell entries Barb @ Work Excel Worksheet Functions 7 April 15th 08 09:01 PM
how to copy the first word or two words from a cell containing a complete sentence to another cell jonny Excel Discussion (Misc queries) 6 January 28th 07 10:23 PM
How do I set up imported data to stack info within a cell? bobwms Excel Discussion (Misc queries) 1 June 15th 06 07:48 PM
How do I set up imported data to stack info within a cell? bobwms Excel Discussion (Misc queries) 0 June 15th 06 07:32 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017