Log in
x
or
x
x
Register
x

or

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 Scope

How to find and replace contents in merged cells in Excel?

How to find and replace in header or footer in Excel?

How to find and replace sheet tab names in Excel?

How to find and replace specific text in text boxes?

How to find and replace string within formulas only in Excel?

How to find and replace text in chart titles in Excel?

How to find and replace text within comments in Excel?

How to quickly find and replace across multiple worksheets or the whole workbook?

How to quickly find and replace in multiple opened Excel files?

How to search/find and replace values in selection or selected cells 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?

Others

How to find and replace exact match in Excel?

How to find and replace multiple values at once in Excel?

How to find and replace values greater than / less than a specific value in Excel?

How to replace filtered data without disabling filter in Excel?

How to replace non empty cells with specific value in Excel?

How to replace range names with cell references in Excel?

How to replace text with corresponding pictures in Excel?