Text wrapping isn't just for word processors. You can wrap text in spreadsheets too. Here's how to wrap text in Microsoft Excel using two different methods.

Adding text to a cell using a custom format instead of typing it clearly labels the data and still lets Excel calculate it. (Click for larger image).

If you want to put a line through your text in Microsoft Office programs like Word or Excel, you have to use the Strikethrough feature.

When you remove the rows, the format also disappears. I’m using Excel 2016 on a Windows 10 64-bit system, but this technique will work in older versions.

Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.