Excel Tips: Edit > Delete and Clear

Remove Characters

Remove Alpha or Numeric Characters

How to remove alpha characters from cells in Excel?

How to remove letters from strings/numbers/cells in Excel?

How to remove non numeric characters from cells in Excel?

How to remove non-alpha characters from cells in Excel?

How to remove non-alphanumeric characters in Excel?

How to remove non-English characters in Excel column?

How to remove numbers from cells which containing texts and numbers in Excel?

How to remove numbers from text strings in Excel?

How to remove numeric characters from cells in Excel?

How to remove only text from cells that containing numbers and texts in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Remove Non-printing Characters

How to delete all blank lines or only the first line in cell in Excel?

How to quickly remove line breaks in Excel?

How to remove non-printable characters from cells in Excel?

Remove Punctuation Marks

How to remove all brackets from string in a range in Excel?

How to remove all commas in Excel?

How to remove all punctuation marks (comma, quotation, apostrophe) from cells?

How to remove first comma from text string in Excel?

How to remove last / ending comma from cell in Excel?

How to remove last/first character if it is a comma or certain character in Excel?

How to remove quote marks around text from cell in Excel?

Remove Characters by Position

How to remove all but first x characters from cells in Excel?

How to remove all characters after the first/last space from cells in Excel?

How to remove anything in brackets in Excel?

How to remove extension from filename in Excel?

How to remove first / last word from text string in cell?

How to remove first or last n characters from a cell or string in Excel?

How To Remove First, Last X Characters Or Certain Position Characters From Text In Excel?

How to remove inverted commas from cells in Excel?

How to remove last / ending comma from cell in Excel?

How to remove last/first character if it is a comma or certain character in Excel?

How to remove leading apostrophe from numbers in Excel?

How to remove leading minus sign from numbers in Excel?

How to remove middle initial from full name in Excel?

How to remove negative sign from numbers in Excel?

How to remove prefix / suffix from multiple cells in Excel?

How to remove text before or after a specific character from cells in Excel?

How to remove text indicator (‘) in Excel?

How to remove text within brackets/parentheses in Excel?

Remove Specified Characters

How to quickly remove dashes from cells in Excel?

How to remove all asterisk characters from cells in Excel?

How to remove all instances of a character in Excel range?

How to remove certain/specific character from cell in Excel?

How to remove plus sign or minus sign of data in Excel?

How to remove some special characters from string in Excel?

How to quickly remove all numberings or bullet points from an Excel column?

Remove Zeros

How to remove all zeros after decimal in Excel?

How to remove leading zeros before decimal point in Excel?

How to remove leading zeros from alphanumeric text string in Excel?

Others

How to mass delete specific word in Excel?

How to remove all decimal points but retain value in Excel?

How to remove duplicate characters or words in string of a cell?

How to remove salutations from names cells in Excel?

How to remove unwanted text from cell in Excel?

Remove Spaces

How to remove extra spaces between words in cells in Excel?

How to remove internal spaces in Excel string?

How to remove leading and trailing spaces in Excel ?

How to remove leading spaces in cells in Excel?

How to remove spaces between characters and numbers within cells in Excel?

How to remove trailing spaces from cells in Microsoft Excel?

How to remove whitespace after text in Excel?

How to remove/delete all spaces after the last character in Excel?

How to replace multiple spaces with single space from cells in Excel?

Others

How to batch remove hyperlinks at once in Excel?

How to delete active workbook (current file) in Excel?

How to delete all but selected ranges in Excel?

How to delete drop down list in Excel?

How to delete extra empty or blank pages in a worksheet in Excel?

How to delete tracer arrows in Excel?

How to quickly delete all named ranges in Excel?

How to remove personal information of a workbook?