Create a table or use an existing table. In this tutorial, we have the text ‘hhans 1997‘ in the text column; we want to substitute the’ h‘ with an ‘s.’ Click the cell where you want to place the ...

The Excel function SUBSTITUTE can replace symbols, numbers, or text. We explain how to use SUBSTITUTE function in Excel effectively.

Let's face it—if you're automating your data workflow with formulas, you shouldn’t be manually rewriting text just to change the case. Luckily, Excel offers handy formulas that allow you to convert ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but the ...

Excel's text formatting capabilities can make the results of your financial, statistical or scientific spreadsheet calculations more esthetically pleasing and easier to follow. You can use one of ...

Trying to make all of the text or words fit properly in your Excel spreadsheet? Learn how to make text fit in Excel with our tutorial.

You can wrap text in Excel in several ways to ensure that all the text in a cell is visible at once. You may also want to edit the cell height.

Using the find and replace ability in Microsoft Excel 2010, you can quickly replace duplicate letters, words and cells in a spreadsheet document of any size. The following also applies to previous ...