CODEWITHSUNDEEP
excelduplicates
yesman89
yesman89

Reputation: 15

Way to separate two duplicates names in a single cell without a indicator?

I have a column that has cells where the name is duplicated in each cell. An example is John DoeJohn Doe is occurring in a single cell and this is the same for the rest of the cells in the column. I know a way to do it with and indicator such as a space or a comma but this one has no indicator I can think of because the names are smushed together. Please help with this problem.

Upvotes: 0

Views: 75

Answers (1)

BigBen
BigBen

Reputation: 50008

Use MID and LEN()/2:

=MID(A1,1,LEN(A1)/2)

enter image description here

Upvotes: 1

Related Questions