in excel how do I "insert" a <CR> into the text ?

I have 3 cells in excell
this,that,theotherting
If I paste it into an email I get
this  that   theotherting

What I want is :
this
that
theotherthing.

I want to insert two more colums in with embedded <CR>
this,<CR>,that,<CR>,theotetheing
TIMFOX123Asked:
Who is Participating?
 
jppintoCommented:
Sorry, use this formula instead:

=A1 & CHAR(10) &B1 & CHAR(10) &C1

jppinto
0
 
jppintoCommented:
If you have your information on cells A1, B1 and C1, then on cell D1 you can put this formula:

=A1 & Chr(10) & B1 & Chr(10) & C1

jppinto

0
 
byundtCommented:
I assume you are copying cells in a row (rather than a column).

In Outlook 2010, I got vertical orientation using a Paste...Keep Text Only

If you have additional columns you want to add, then you must turn it into a table in your email. Once you do this, you can use the Table Tools...Layout...Insert Column menu item. You can then use the Paste...Keep Text Only trick once again.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
jppintoCommented:
This will make your cell content show as:

thisthattheotherthing

unless you select the cell and go to Format Cells, Alignment tab and on the Text control check the Wrap text option. But when you copy the information on the cell into an email for instance, it will show up with the carriage return.

jppinto
0
 
HainKurtSr. System AnalystCommented:
Alt+ENTER while you enter
0
 
jppintoCommented:
Alt+Enter would do it if the information where to be on only one cell. The user want to join information from 3 diferent cells in this case...
0
 
TIMFOX123Author Commented:
Hello

I want to take information in a row in a spreadsheet.

I want to paste it in a "collumn" into an outlook email


\
0
 
byundtCommented:
TIMFOX123,
Which version of Outlook are you using? I gave you step by step instructions for the copy from a row in Excel and paste in a column in Outlook 2010 in my first Comment.

Brad
0
 
TIMFOX123Author Commented:
2007

Sorry, I missed that question.

My bad
0
 
byundtCommented:
I believe that Outlook 2007 also has a Paste...Keep Text Only feature.

Outlook 2007 should furthermore have a Paste...Set Default Paste... menu item (I see in the Format Text menu in Outlook 2010). You can use this menu item to set the default paste method to Keep Text Only when pasting from other applications (instead of the option to retain formatting).
0
 
TIMFOX123Author Commented:
this worked.  

I tried all types of pastes, all cells come up on the same line.  

the paste thing would have really rocked ( as an alternative solution. )

with the Char thing, I can do mutiple lines  ;)

thank you all
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.