Delete duplicates within a single cell?

[thomasdoles]

Hey guys. So Ive been working on getting information for everyone in my company for a while now, and im finally in the final steps. After combining all of the worksheets, and then combining rows (same name rows combined, semicolon seperates data from duplicate row), I have duplicate information in single cells. Does anyone know how I can fix that and only keep the unique information?

Ive uploaded a column from my sheet that I need to do this for.

Thanks!

 

[AlanSidman]

In column B, = Left(A1,4) and copy down.

 

[thomasdoles]

Thank you! What about if i wanted to do it with the email column?

currently it looks like: jon.daniels@company.com;jdaniels@company.com

I want it to look like: jon.daniels@company.com

Since all names have a different amount of characters, I can not specify how many characters i want to keep.

Any Ideas?

Thanks,
Thomas

 

[AlanSidman]

Assume your data in A1, then in B1 =LEFT(A1,FIND(";",A1,1)-1) and copy down.

 

[NARAYANK991]

Hi ,

To add to what has already been posted , just in case there is no duplicate in a cell (and therefore the semi-colon might not be present in the cell) , the following will still return a valid result :

=LEFT(A2,FIND(";",A2 & ";",1)-1)

Narayan