Excel REPLACE

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. Get Text before Dash Character with Formula Get Text after Dash Character with Formula Get Text Values before and after Dash Character… 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 »

Sidebar