Go to Home –> Find and Select –> Replace (Keyboard Shortcut – Control + H). Click on the Options button. This will expand the dialogue box and show you more options. Click on the Find what Format button. In the example, 'MS Excel is cool' is the existing text where you want to use the REPLACE function. The second argument value is given as 1 which is the . The power of Microsoft Excel lies in its formulas. . In this article, you'll learn how powerful Microsoft Excel formulas and conditional formatting can . Cool, right? We've rounded up 11 different Excel hacks you're sure to use and love. . term you want to find in the spreadsheet, as well as what you'd like to replace it with. Dec 14, 2017 - How to replace words; extract first and last words, matched or a specific words in a string of text. May 12, 2018 - Change-the-Gridline-Colour-for-any-Worksheet Amazing Excel Tips Make your reports look super cool and save valuable column width by . Jan 11, 2017 - Add Cool Features to Your To Do Lists in Excel. Jon Wittwer You can change the color of the bar by just changing the font color. That's a . Apr 11, 2012 - Excel's conditional formatting feature can do a whole lot more than many . To find the largest duplicate value, substitute the MIN() function with . Mar 7, 2013 - These 10 tips will help users get more out of Excel's formatting features. . of digits, making them easier to read, but without changing the scale. Mar 3, 2015 - Microsoft Excel is an amazing piece of software, and even regular users might not be getting as much out of it as they can. Improve your Excel .