Replace multiple occurrence of string with another string in a particular column in excel

[ClaytonM]

Like what @vvaidya posted you can execute key combinations that access the Excel menus; by pressing Alt you will see letters appear above the menu options, so maybe Alt+a+m is an option to Remove Duplicates. (for example, Select Range then TypeInto “[k(alt)]am” or Send Hotkey)

Are you wanting to find the unique values in a row or in a column? The solutions might be different. But, you can look into LINQ solutions that are the fastest and more reliable, I think:

Remove Duplicates with LinQ

Hi there, I need to remove duplicates from a DataTable using LINQ. Specifically, I need to filter out all duplicates for a single column, maintaining the initial Datatable strucutre. Other methods, such as DefaultView, do not work as they print out only one column (the one containing duplicates). Any suggestion would be highly appreciated, code examples would be terrific. Thanks in advance for your help! Nicolò

You can also convert the table to a string with Output Data Table, then use .Replace if you only want to replace certain words. Probably not the ideal method for your goal of getting rid of duplicates.