When this happens, we must convert that text into numbers before we can use the data. SEE: 83 Excel tips every user should master (TechRepublic) In this Microsoft Excel tutorial, I’ll show you ...

Then select the cells stored as text. Excel doesn’t convert numbers written in text into digits if you import data from another source because of the default setting. That being said ...

You can separate numbers from text in Excel, provided you specify what needs to be separated. Open the Excel file that contains the garbled data. Take a good look to see where the data has been ...

Number, and Text filters to your spreadsheet. To make it easier for you to practice the filtering tasks we’re about to describe, we’ve created a downloadable Excel workbook with all the data ...

This poor soul was manually rekeying the number and the labels, and she had 700 rows of data. Fortunately, I was able to come to my coworker’s rescue by showing her how to use Excel’s Text To ...

Let's face it—if you're automating your data workflow with formulas, you shouldn’t be manually rewriting text just to change ...

and roman numeral numbers in front of the text. In Excel, this feature only works with text boxes, and it is not in Excel by default.

Microsoft Excel may be a productivity app that emphasizes numbers, but it has useful tools for text as well. For instance, that handy spreadsheet app will let you wrap text. And getting it done is ...