Microsoft Excel Functions & Formulas

Use the SUBSTITUTE function to remove

word-wrapping in cells

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.

4

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)," ...