Clean Data is an AI feature in Excel that automatically finds inconsistent data and suggests error corrections. It works with data tables and usually, within their columns, finds excess spaces, uneven use of lowercase and uppercase characters, non-conforming formats, blank values, duplicates, errors… This option sometimes runs automatically, immediately after opening the document, and you can also run it manually…