Forum Discussion

nickyshfs's avatar
nickyshfs
Copper Contributor
Dec 16, 2022

multiple lines of text within text output of formula

I would like it so that if someone keys "SO P" into cell B1, then the output is the following text within the selected cell (note, I'D LIKE MULTIPLE LINES OF TEXT WITHIN THE ONE CELL:   Full value ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Dec 16, 2022

nickyshfs 

Use

=IF(B1="SO P", "Full value =" & CHAR(10) & "Share value =","")

Entering a line break in a formula only changes the way the formula is displayed. To enter a line break in the result, concatenate with CHAR(10), the line break character.

  • nickyshfs's avatar
    nickyshfs
    Copper Contributor
    Dec 16, 2022
    thank you so much! But I've tried this and am still getting the same result...?
    • nickyshfs's avatar
      nickyshfs
      Copper Contributor
      Dec 16, 2022
      I can't see how I can add an image into a reply so have put it in my main post....
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Dec 16, 2022

        nickyshfs 

        Make sure that you turn on Wrap Text for the cell(s) with the formula:

         

         

Resources