how to delete duplicated content from 2 cells

[lucent88]

Hi everyone,

this is my first time to this forum, looks like there are alot o
information on this site, but I can't seem to find my solutions, see i
anyone can hlep me out here.

I was just wonder is there a formula that i can instantly delete th
duplicated contents from 2 cells.

example.

A1 _Honda_Civic_ B1 _Civic_

I want a formula for C1 to show _Honda_

Because Civic is the duplicated content between these 2 cells.

Is there a way to do it? :confused

 

[Guest]

How about =substitute(a1,b1,"") ? That would delete any instance of b1
within a1. If there's no instance of b1 in a1, you just get a1 back in its
entirely.

 

[Richard Buttrey]

Hi everyone,

this is my first time to this forum, looks like there are alot of
information on this site, but I can't seem to find my solutions, see if
anyone can hlep me out here.

I was just wonder is there a formula that i can instantly delete the
duplicated contents from 2 cells.

example.

A1 _Honda_Civic_ B1 _Civic_

I want a formula for C1 to show _Honda_

Because Civic is the duplicated content between these 2 cells.

Is there a way to do it?

=LEFT(A1,LEN(A1)-(FIND(B1,A1)-1))

Arguably the duplicated content is _Civic_ and the unique bit would
therefore be _Honda

in which case the formula would be

=LEFT(A1,LEN(A1)-FIND(B1,A1))


That will handle the example you quote, but how would you want to
handle say:

A1 Honda_Civic_AAA
B1 _Civic_


would you expect
_HondaAAA

Post back with further examples if necessary.

Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________