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

Open in new window


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

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

See attached.
0
 
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.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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

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

Set the text in the cell to 'wrap'.

See attached Version 1 of your file.

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