Fresh Excel Tips

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.

How to remove word wrapping in cells:

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

You should now be set.

1. How to Determine the ASCII/Numeric Code using Excel
2. Using the SUBSTITUTE function to substitute parts of a cell
3. Using the SUBSTITUTE function to substitute characters in Excel
4. Using the CHAR Function to Discover special characters in Excel
5. Using the OR function to check cells for text or numbers in Excel