Delete duplicate data in a single cell
Thank you, ryguy7272.
I tried the formula supplied and here's the result:
Field A1 data: CRYSTAL BERNIER CRYSTAL BERNIER
Field A1 data (after formula): CRYSTALAL BERNIER
As you can see, the formula sucessfully removed the duplicate first/last
name, however, it added additional letters to the first name. This occured
in the subsequent list fields as well. Any way to get it to display just the
unique name value without the additional letters?
"ryguy7272" wrote:
I think this will work for you:
=LEFT(A1,FIND(" ",A1,1)-1)&RIGHT(A1,FIND(" ",A1,1)+2)
Regards,
Ryan---
--
RyGuy
"kacey28" wrote:
I have a spreadsheet provided by an outsourced company that has duplicate
data within a single cell. For example, a cell with Name values will have
"Jerry White Jerry White" (twice), rather than once "Jerry White".
When duplicate values appear in the same cell, how do you manage to clean
these up without manually deleting data in each individual cell? (Note - I
have several columns that contain various duplicated data.)
Thanks in advance for any help!
|