![]() Here’s what it looks like when you land on the Replace tab: To land on the Replace tab instead, use Ctrl+H:įind & Replace Dialog Box – On “Replace” Tab (keyboard): Ctrl+H Here’s what it looks like when you land on the Find tab: (I have a more extensive post on how Alt shortcuts work). The first two default to the Find tab.įind & Replace Dialog Box – On “Find” Tab (keyboard #1): Ctrl+Fįind & Replace Dialog Box – On “Find” Tab (keyboard #2): Alt-E-EĪlt-E-E is a legacy Alt shortcut, from the menu system that went away after Excel 2003. What Are Some Good Find And Replace Excel Shortcuts? I don’t recall reading about it anywhere, so may be I should patent it… It can save you a ton of time. The “replace with nothing” technique, for some reason, isn’t widely written about. ![]() The same thing if you only want to clean up one block of cells (just select the block of cells first). If you only want to clean up one column, just select that column first. To remove all dashes and everything before them, replace “*-” with nothing.To remove all dashes and everything after them, replace “-*” with nothing (the * serves as a wildcard). ![]() ![]() To remove all blanks, replace ” ” (a blank) with nothing.To remove all # signs, replace # with nothing.What’s A Good Use For Find And Replace In Excel?įind and Replace can be a great way to clean up data in Excel.
0 Comments
Leave a Reply. |