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

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
Who is Participating?
Wilder1626Connect With a Mentor Commented:
="The new title is:" & CHAR(10)  &  B3

Open in new window

Then, click on WRAP TEXT
wrap text
Katie PierceCommented:
I would suggest two separate cells.

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

See attached.
kbay808Author Commented:
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.
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Katie PierceCommented:
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.
kbay808Author Commented:
That worked great.  Thanks for the visual aid too.  That was very helpful.

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

Set the text in the cell to 'wrap'.

See attached Version 1 of your file.

i'm glad i was able to help
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.