How to force text onto a second line within a cell that contains a formula?

Posted on 2015-01-13
Last Modified: 2015-01-13
I tried the Alt Enter method, but it does not work with a formula.

Example of desired output:      
“The new title is:
Going Strong”

Fixed text:
“The new title is:”

Variable input field in cell B3: (Value will vary in character length and word count)
“Going Strong”

Current formula (Please see the attached workbook)
="The new title is:"&B3
Question by:kbay808
  • 2
  • 2
  • 2
  • +1

Expert Comment

by:Katie Pierce
ID: 40548031
I would suggest two separate cells.

"The new title is:" in B4
"=B3" in B5

See attached.

Author Comment

ID: 40548044
I need this to update a current tool that I can’t add another cell to.  The cell produces the notes that the user copies and pastes into a work log.  I need it all to be in 1 cell.

Expert Comment

by:Katie Pierce
ID: 40548056
Hmmmmm, the only other trick I could think of would be to add spaces to the result:

="The new title is:                                           "&B3

This would give you a set amount of space following the static info, but since the title would be of varying length, it might not work.  But you could give it a try and put in a max number of spaces you think would work.  Then set the column width to accommodate that.
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

LVL 11

Accepted Solution

Wilder1626 earned 500 total points
ID: 40548060
="The new title is:" & CHAR(10)  &  B3

Open in new window

Then, click on WRAP TEXT
wrap text

Author Closing Comment

ID: 40548067
That worked great.  Thanks for the visual aid too.  That was very helpful.
LVL 12

Expert Comment

ID: 40548068

="The new title is:"&char(10)&B3.

Set the text in the cell to 'wrap'.

See attached Version 1 of your file.

LVL 11

Expert Comment

ID: 40548069
i'm glad i was able to help

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Route Recommendation 18 31
Excel VBA 10 39
Excel Drop Down List 13 32
formatting - number format 2 12
INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question