☰

Excel 删除带有空格的重复值

tag-icon • tag-icon microsoft-excel
Excel 删除带有空格的重复值

我正在尝试从 excel 列中删除重复项。我尝试使用 excel 中内置的删除重复值功能。

最初我有以下数据

 University of South Florida College of Medicine
 University of South Florida College of Medicine
 University of South Florida College of Medicine
 University of South Florida College of Medicine 
 University of South Florida Morsani College of Medicine
 University of South Florida Morsani College of Medicine 
 University of South Florida Morsani College of Medicine 
 University of South Florida Morsani College of Medicine 
 University of Tennessee College of Medicine  
 University of Tennessee College of Medicine
 University of Tennessee College of Medicine 
 University of Texas Medical Branch
 University of Texas Medical Branch 
 University of Texas Medical School
 University of Texas Medical School 
 University of Texas Medical School

使用删除重复项功能后，我仍然留下一些重复项经过进一步分析后，我意识到第二行末尾有一些额外的空间

 University of South Florida College of Medicine
 University of South Florida College of Medicine 
 University of South Florida Morsani College of Medicine
 University of South Florida Morsani College of Medicine 
 University of Tennessee College of Medicine
 University of Tennessee College of Medicine 
 University of Texas Medical Branch
 University of Texas Medical Branch 
 University of Texas Medical School
 University of Texas Medical School 

 University of Texas Medical SchoolNOSPACE
 University of Texas Medical School ONESPACE

如何删除末尾有额外空间的重复项？

答案1

首先使用TRIM，它将从源数据中删除任何额外的尾随（或前导）空格。

因此，如果您的数据以 开始A2，请在 中写入以下内容B2：

=TRIM(A2)

并将其复制或拖动到列中，B直到覆盖所有数据。为了更加干净，您现在可以复制 中的所有内容B，然后粘贴值，并删除列A。然后Remove Duplicates在新的干净数据上使用。

相关内容