Remove duplicate text in same cell; no delimiter

[slam]

I have a column with a list of tanks that comes from a website. When I copy/paste from this website, it duplicates the names, so for instance, Archer becomes ArcherArcher, E 25 becomes E 25E 25, 121 becomes 121121, and so on. Is there a formula or VBA that could remove the duplicate? It's about 800 rows, and I have to do this on a regular basis.

This for Excel 2019.

Thanks!

 

[hagia_sofia]

Hello, if it is an exact copy maybe you could just use:

=LEFT(A1,LEN(A1)/2)

 

[slam]

Edit: My mistake, had a cell reference incorrect. Thank looks to be working perfectly! Thank you!