Some formulas to try:
=IF(A1=B1,A1,"")
=IF(FIND(B1,A1),A1,"")
=IF(SEARCH(B1,A1),A1,"")
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"myguess21" wrote in
message ...

Thanks for quick response.

No this is string. Just want to search the value from column 2 in
column1 if found out put in column 3.


--
myguess21
------------------------------------------------------------------------
myguess21's Profile:
http://www.excelforum.com/member.php...o&userid=29578
View this thread: http://www.excelforum.com/showthread...hreadid=492781