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?

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?
>
>
> --
> 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
<lucent88.1wt4yh_1129151125.3151@excelforum-nospam.com> 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?

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