Help with Sorting\Duplicates

New Contributor

Hi there, I'm trying to group duplicates but excel does not see A020601E and A02-06-01E as a duplicate due to the dashes. Is there a way to trick it into thinking this ?


2 Replies



A few options might work for you depending on version and data set.


Formula (see attached xlsx):



You might also consider creating a custom list and then sorting on the custom list if the number of unique items you have is reasonable.

Sort data using a custom list (

thank you, this formula will at least allow me to now highlight duplicate values and count available space faster.