Remove non exact duplicate values

[dutchmenqb]

Hello all,

I'm look for a way to remove duplicate values that are not an exact match. The processes from everywhere I look seem to not work.

Example:

Original values:
Wal-mart #2501
Wal-mart #2600
Wal-mart #5164

Change to new value:
Walmart

Thanks for any and all help

 

[Mike Szczesny]

Can you use something like this? Do you just want to change all items having "Wal-mart" to "Walmart"?

Excel 2012
	A	B	C
1	Wal-mart #2501		Walmart #2501
2	Wal-mart #2600		Walmart #2600
3	Wal-mart #5164		Walmart #5164
Sheet2

Cell Formulas
Range	Formula
C1	=SUBSTITUTE(A1,"Wal-mart","Walmart")