USE THE SUBSTITUTE FUNCTION TO REMOVE WORD-WRAPPINGS IN CELLS USING MICROSOFT EXCEL

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

USE THE SUBSTITUTE FUNCTION TO REMOVE WORD-WRAPPINGS IN CELLS USING MICROSOFT EXCEL