Sometimes when I want to find a name in a list using Find and Replace option, but I make a mistake when typing the name, the result won't come up. So is there a way in Excel that suggests recommendations just the way the search engine works?
For example: the correct name in Excel is: michael jackson
but the wrong name that I typed in the find and replace is: machal jakson
So, I want Excel to suggest me the correct name instead of "Microsoft Excel cannot find the data you're searching for"
Thank you
For example: the correct name in Excel is: michael jackson
but the wrong name that I typed in the find and replace is: machal jakson
So, I want Excel to suggest me the correct name instead of "Microsoft Excel cannot find the data you're searching for"
Thank you