4/5/2023 0 Comments Kutools excel for macIn the Fuzzy Lookup pane, please configure the following settings: Activate the worksheet contains the text values you want to correct, and then click Kutools > Find > Fuzzy Lookup to enable the Fuzzy Lookup pane, see screenshot:Ģ. To find the similar misspelled texts and then correct them to your own needed value, please do with the following steps:ġ. But, with the Kutools for Excel’s Fuzzy Lookup function, you can quickly check for the similar records based on character differences, and then correct them to your own text at once.įind and replace the similar records from a list of cell values In Excel worksheet, entering a list of same text manually may contain some typos, if you want to find the similar but misspelled text, generally, you should check and correct them one by one.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |