You can prevent Excel from converting numbers to scientific notation. This post shows how to remove scientific notation in Excel.

You can use Excel's built-in substitute function to remove or replace a substring of a string of characters in Excel. This can include removing hyphens from Social Security numbers or any other ...

2] Remove dashes in Excel by using the Find and Replace method This method does not work if a particular format is already applied to your cells, say SSN (Social Security Number) format.

If your spreadsheet has a lot of unwanted duplicate values, you're not stuck with them. You can remove them. We'll show you how to remove duplicates in Excel.

How to Remove Extra Unused Cells in Microsoft Excel 2013. Worksheets in Microsoft Excel can contain over a million rows and over 15,000 columns. With a workspace that large, if you're not careful ...