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

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

What I want is :

I want to insert two more colums in with embedded <CR>
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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


byundtMechanical EngineerCommented:
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.
Sorry, use this formula instead:

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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

This will make your cell content show as:


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.

HainKurtSr. System AnalystCommented:
Alt+ENTER while you enter
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...
TIMFOX123Author Commented:

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

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

byundtMechanical EngineerCommented:
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.

TIMFOX123Author Commented:

Sorry, I missed that question.

My bad
byundtMechanical EngineerCommented:
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).
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.