You can use this same formula to remove other characters from a string of values in Excel. You can also use the Right function, where you tell Excel to delete the numbers on the left and keep the ...

If you are just looking to get rid of the numbers after the decimal point, using the INT function with your RAND function should do the trick. Open a new Microsoft Excel 2010 spreadsheet.

Taking the above example, we may remove extra spaces between characters and numbers in Excel using the SUBSTITUTE() function as follows: Place your cursor on cell C5 and type the following ...

For example, instead of adding several numbers one by one, which can take a while, you can use the =SUM(A2:A6) function. This tells Excel to add all the numbers from cells A2 to A6 in one simple step.

Excel's Trim function will remove all but one space between words; however, it cannot remove non-breaking spaces – this requires a combination Excel's Substitute and Trim functions.

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 ...