Help in removing duplicate strings in cell without macros/VBA

[xcellerator]

I have a number of cells and I am looking to remove the duplicate strings (2 characters or more) in them.
Is this possible with an existing Excel formula(s)? It's ok if I need to use helper columns (C, D, E...)

For example:
A1 = Jane & Bob Smith Smith
A2 = Joe Johnson Johnson
A3 = Sally and Bill Jones
A4 = Ann and Tim Adams Adams
A5 = Ben

then have a formula to convert into
B1 = Jane & Bob Smith
B2 = Joe Johnson
B3 = Sally and Bill Jones
B4 = Ann and Tim Adams
B5 = Ben

Can I do this without any macros/VBA?

 

[footoo]

If the duplicated words are always the last and second last words :

=IF(TRIM(LEFT(RIGHT(" "&SUBSTITUTE(TRIM(A1)," ",REPT(" ",60)),120),60))=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100)),LEFT(A1,LOOKUP(2^15,FIND(" "," "&A1,ROW(INDIRECT("1:"&LEN(A1)))))-1),A1)

 

[jtakw]

Hi,

Also assuming the duplicate word, if any, is always the Last word:

Book1
	A	B
1	Jane & Bob Smith Smith	Jane & Bob Smith
2	Joe Johnson Johnson	Joe Johnson
3	Sally and Bill Jones	Sally and Bill Jones
4	Ann and Tim Adams Adams	Ann and Tim Adams
5	Ben	Ben
Sheet291

Cell Formulas
Range	Formula
B1	=TRIM(SUBSTITUTE(A1,TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)),"",2))

Formula copied down.

 

[xcellerator]

My error in initial question!

Is there a way to do this if the word is not always the last word?
I have cases such as "Jane Smith & Bob Smith", which would want to turn into "Jane & Bob Smith" (so basically remove the 1st occurrence of the word is best).

 

[jtakw]

So, are you saying you have Some strings as described in OP Post # 1, AND, you have Some strings as described above ( Post # 4 )?? That BOTH types of strings are possible, so sometimes you need the First duplicate removed, but sometimes you need the Second duplicate removed ??

 

[xcellerator]

Actually always only the first string needs to be removed. Sorry for lack of clarity!

 

[jtakw]

But you might still have strings like below as shown in OP, where there's No duplicate, is that correct ?

A3 = Sally and Bill Jones