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