Find or replace text and numbers on a worksheet | excel replace all text with different text
Find Tofindsomething,pressCtrl+F,orgotoHome>Editing>Find&Select>Find. Note: Inthefollowingexample,weveclickedtheOptions>>buttontoshowtheentireFinddialog.Bydefault,itwilldisplaywithOptionshidden. IntheFindwhat:box,typethetextornumbersyouwanttofind,orclickthearrowintheFindwhat:box,andthenselectarecentsearchitemfromthelist. Tips: Youcanusewildcardcharacters —questionmark(?),asterisk(*),tilde(~) —inyoursearchcriteria. Usethequestion...
FindTo find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.
Note: In the following example, weve clicked the Options >> button to show the entire Find dialog. By default, it will display with Options hidden.
In the Find what: box, type the text or numbers you want to find, or click the arrow in the Find what: box, and then select a recent search item from the list.
Tips: You can use wildcard characters — question mark (?), asterisk (*), tilde (~) — in your search criteria.
Use the question mark (?) to find any single character — for example, s?t finds "sat" and "set".
...