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
Comment Utility
I would suggest two separate cells.

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

See attached.

Author Comment

Comment Utility
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
Comment Utility
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.
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

LVL 11

Accepted Solution

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

Open in new window

Then, click on WRAP TEXT
wrap text

Author Closing Comment

Comment Utility
That worked great.  Thanks for the visual aid too.  That was very helpful.
LVL 12

Expert Comment

Comment Utility

="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

Comment Utility
i'm glad i was able to help

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
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…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now