How to remove word wrapping in cells using 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, [...]
Using the SUBSTITUTE function to substitute parts of a cell
Previously, we had used the SUBSTITUTE function to replace characters in a cell, you can view that tutorial HERE. Today, we’ll be using this function to replace “-” with a blank space, not only that but we want only the first occurrence of it to be replaced. For example, we have 333-444-555, the value we [...]
