Excel REPLACE - Free Excel Tutorial

How to Get Text before or after Dash Character in Excel

This post will guide you how to get text before or after dash character in a given cell in Excel. How do I extract text string before or after dash character in Excel. 1. Video: Get Text before or after Dash Character in Excel You can watch this short video tutorial to learn how to… read more »

How to Insert Dashes in Phone Numbers in Excel

This post will guide you how to insert or add dashes in phone number with a formula in Excel. How do I add dashes to telephone numbers in a selected range in Excel. How to separate numbers with dashes in Excel. Insert Dashes into Phone Numbers Using Functions Insert Dashes into Phone Numbers Using Format… read more »

Fill Blank Cells with specific value (0 or null)

This post will teach you how to fill all blank cells with specific value, such as: 0 or any other values in excel. How to locate all blank cells and then fill in all the blanks with any specific value. The below will guide you to fill empty cells with different ways in excel 2016… read more »

Delete Rows Based on Cell Value

This post will guide you how to use the Find & Replace feature to delete or remove all rows based on certain cell value in Microsoft Excel. Or how to delete all rows that contain certain value with VBA code in excel, such as, removing all rows if cell contains 0 or any other value…. read more »

How to Copy Formula without Changing Cell References

This post will guide you how to copy formula without changing its cell references to make an exact copy in excel. How to copy and paste formulas or links without changing Cell References. How to copy exact formula from one cell to another cell. Copy Formula without Changing Cell References You copy formulas from a… read more »

How to Check If the First Letter is capitalized

This post explains that how to check if the first letter in a cell is capitalized or not in excel. How to write an excel Macro to check if the first letter in a specified cell is capitalized or not. How to test if the first letter in a table cell is capitalized with VBA… read more »

How to remove all spaces between numbers or words

This post will describe two quick ways to remove all space characters between numbers or words in excel. How to remove unwanted spaces from cells in a select range of cells in Excel. Assuming that you have a list of data with text string and numbers in one cell, and you want to remove all… read more »

How to replace all characters after the first specific character

This post will guide you how to replace all characters after the first match of a specific character with a new text string in excel. How to replace all substrings after the first occurrence of the comma character with another substring in a text string using excel formula. How to replace all old_text with new_text… read more »

How to remove text after a specific character

We talked that how to remove all characters before the first match of the comma character in the previous post. And this post will teach you how to remove text after the first occurrence of the comma character in a text string in excel. Remove text after a specific character If you want to remove… read more »

How to remove text before the first match of a specific character

This post explains that how to remove text before the first occurrence of the comma character in a text string in excel. How to remove all characters before the first match of the comma or others specific characters in excel. Remove text before the first match of a specific character If you want to remove… read more »

The difference between Replace function and Substitute function in Excel

There are two similar functions to replace text string in Excel. They are REPLACE and SUBSTITUTE functions. What’s the difference between REPLACE function and SUBSTITUTE function in excel 2013?  This post will introduce the difference between those two function in excel. SUBSTITUTE Function The Excel SUBSTITUTE function replaces a new text string for an old… read more »

Using Find and Replace Tool to replace text in Excel

In some previous posts, I have talked that how to use the REPLACE function or Substitute functions to replace text string. And this post will guide you how to use Find and Replace tool to replace text from a worksheet in excel. The Find and Replace tool is a very useful tool to replace the text… read more »

Excel Replace Function Remove Text String

This post will teach you how to remove a text string of specified length from another text string in a cell. Excel Replace Function Remove Text String If you want to remove text string from a cell in excel, you can use the REPLACE function. It can remove the text string by position in a… read more »

Combining the Replace function with Text function in Excel

In excel, we can use Replace function in combination with Text function to replace date characters that are part of the text string. And this post will guide you how to use TEXT function as the first arguments to replace text string in REPLACE function in excel 2013. We have talked in the previous post… read more »

Excel Replace Function

This post will guide you how to use Excel REPLACE function with syntax and examples in Microsoft excel. Description The Excel REPLACE function replaces all or part of a text string with another text string The REPLACE function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The REPLACE function is… read more »

Sidebar