How to Remove duplicate names within excel cell

[satish78]

Hi,

For now, I am cleaning all list manually and taking long hours to .

Here are the sample list and sample results

Blackledgedblackledge@riverhillsbank.com
Vanderhoffmvanderhoff@franklinloans.com
Stanwixastanwix@greenwaldindustries.com
Smithjacques.smith@greatwesternbank.com
Meadowspmeadows@centurynationalbank.com




results after cleaning


dblackledge@riverhillsbank.com
mvanderhoff@franklinloans.com
astanwix@greenwaldindustries.com
jacques.smith@greatwesternbank.com
pmeadows@centurynationalbank.com

Is there any better way to do it with Formula or VBA.

 

[ranman256]

did you use the remove duplicates function?
1 click ,not long hours.

 

[satish78]

Thats not exactly remove duplicates.
Its remove duplicate names within cell (I mean each cell). If you take a look names starting and ending before"@" symbol, you will understand.