how to delete duplicated content from 2 cells
 

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:


--
lucent88
------------------------------------------------------------------------
lucent88's Profile: http://www.excelforum.com/member.php...o&userid=28049
View this thread: http://www.excelforum.com/showthread...hreadid=475596

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.

"lucent88" wrote:


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:


--
lucent88
------------------------------------------------------------------------
lucent88's Profile: http://www.excelforum.com/member.php...o&userid=28049
View this thread: http://www.excelforum.com/showthread...hreadid=475596

On Wed, 12 Oct 2005 15:24:18 -0500, lucent88
wrote:


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:

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