➤ Go to Home Tab > Editing Group > Find & Select Dropdown > Replace Option. ➤ Select the cells of the >2000 or not column. In this section, we will use the Replace option to replace text Yes with Greater than 2000 in the formula of the >2000 or not column. Method-2: Using Replace Option to Replace Text in Excel Formula Read More: How to Find and Replace in Excel Column (6 Ways) In this way, you will be able to replace Yes with Greater than 2000 in the formula. ➤ Press ENTER and drag down the Fill Handle tool. ➤ Replace Yes with Greater than 2000 in the formula bar manually. So, it is showing the formula of this cell in the formula bar. ➤ Select the first cell of the column >2000 or not. Now, we want to replace Yes with Greater than 2000 in the formula manually. Here, we have used a formula with the IF function and got Yes for the prices which are greater than 2000. Method-1: Replace Text in Excel Formula Manually We have used Microsoft Excel 365 version here you can use any other version according to your convenience. Here, we have two formulas in the Discounted Price column and >2000 or not column and we will show the ways to change the text string or numeric string in these formulas. 7 Methods to Replace Text in Excel Formula
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |