Use the SUBSTITUTE function to remove word-wrapping in cells - Text Functions - Microsoft Excel Tutorials

To wrap text in a cell, you can select Cells from the Format menu, select the Alignment tab, and activate the Wrap text check box. Another way to do this is to type the first row of a cell, then press <-Alt+Enter->, type the next line, and continue as desired.

If you want to disable word-wrap, the SUBSTITUTE and CHAR functions can be used together. CHAR returns the character specified by a number. The ASCII character numerical equivalent for word-wrap is 10.

To delete word-wrap:

1. In cells A2 and A3 type text with word-wraps.
2. Select cells B2:B3 and type the following formula: =SUBSTITUTE(A2,CHAR(10)," ").
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=Nd0iG8rM9oM

  Hope You Like This Tutorial - Give Comments