Excel Tips: Excel > Replace

Replace Characters

How to change – (dashes) to 0 (zero) in Excel?

How to change or find and replace first number in cell in Excel?

How to convert carriage return to comma in Excel?

How to convert zero to blank in selected range in Excel?

How to convert zeros to dashes in Excel?

How to find and replace asterisk / question mark / tilde in Excel?

How to replace accented characters with regular characters in Excel?

How to replace all after/before specific character or space in Excel?

How to replace all numbers in cells with X’s in Excel?

How to replace alt-enter with space/comma in Excel?

How to replace blank space with nothing/underscore/dash/comma in Excel?

How to replace commas with newlines (Alt + Enter) in cells in Excel?

How to replace first n character or nth occurrence of character with another in Excel?

How to replace line breaks with br in Excel?

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

How to replace nth/all occurrences of a character in string in Excel?

How to replace the last comma with and in cells in Excel?

How to replace tilde and wildcard characters in Excel?

Replace Errors

How to change #DIV/0! error to the readable message in excel?

How to replace # formula errors with 0, blank or certain text in Excel?

Replace with Formatting

How to find and replace fill color in Excel?

How to find and replace numbers with subscript in Excel?

How to find and replace text then preserve formatting in Excel?

How to quickly find and replace character with superscript in Excel?