Wrap text string text in cell using formula

[sspatriots]

Hi,

I tried using the "CHAR(10" inserted into this string of text in a formula to get it to wrap the text string in several places, however, it would not work. I don't want to set the whole column to wrap text.

="TBD or"&CHAR(10)&"Select NA"&CHAR(10)&"for Vendor"


Therefore, I tried the following formula, (something I got the idea from in another post of mine a few weeks back, but it would not wrap the texts either. If anyone can show me a way to do this with a formula, it would be greatly appreciated. Thanks, SS

=TEXTJOIN(CHAR(10),,TRIM(TEXTSPLIT("TBD or Select NA for Vendor"," ")))

 

[Georgiboy]

Can you not just set the result cell to wrap text?

The CHAR(10) won't do anything unless the cell format is set to wrap text. Both of your formulae wrap the text but in different places.

Here is another formula that does the same as your first formula:

=LET(t,{"TBD or","Select NA","for Vendor"},TEXTJOIN(CHAR(10),,t))

 

[Scott Huish]

To do that, select the cells you want this to happen on, hit CTRL-1
Click on the Alignment tab, under Text Control, click on Wrap Text. Click OK.

 

[sspatriots]

Can you not just set the result cell to wrap text?

The CHAR(10) won't do anything unless the cell format is set to wrap text. Both of your formulae wrap the text but in different places.

Here is another formula that does the same as your first formula:

=LET(t,{"TBD or","Select NA","for Vendor"},TEXTJOIN(CHAR(10),,t))

Perfect. Thank you, I can work with this.

 

[Georgiboy]

You're welcome, glad we could help.