Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


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

Posted on 2015-01-13
Medium Priority
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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 11

Accepted Solution

Wilder1626 earned 2000 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 18

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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.

598 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