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:

       

       

      • nickyshfs's avatar
        nickyshfs
        Copper Contributor
        Dec 16, 2022
        you're a superstar - thank you so much!

Resources