how to delete duplicated content from 2 cells

  • Thread starter Thread starter lucent88
  • Start date Start date
L

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
 
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.
 
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? :confused:
Click to expand...

=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
__________________________
 
Back
Top