Alt Enter for Careg Return

frankday

Board Regular
Joined
Apr 13, 2012
Messages
94
I am using the following formula.

="Beginning Balance "&TEXT(AE10,"$#,##0")&" Capital Account Estimated Balance "

I want it to show up in the cell on two lines. Like ALT ENTER does. I want the " Capital Account Estimated Balance " on the second line.
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
35,511
Office Version
2010
Platform
Windows
I am using the following formula.

="Beginning Balance "&TEXT(AE10,"$#,##0")&" Capital Account Estimated Balance "

I want it to show up in the cell on two lines. Like ALT ENTER does. I want the " Capital Account Estimated Balance " on the second line.
="Beginning Balance "&TEXT(AE10,"$#,##0")&CHAR(10)&"Capital Account Estimated Balance"
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
Cross posted https://www.excelforum.com/excel-general/1220002-alt-enter-in-a-formula.html

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
 

Forum statistics

Threads
1,082,588
Messages
5,366,490
Members
400,895
Latest member
shumcal

Some videos you may like

This Week's Hot Topics

Top