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