copy this formula in sheet2 at x1 cell and drag it down till the last
cell you want to copy.

=IF(ISERROR(FIND("cash",Sheet1!X1,1)),"",Sheet1!X1 )


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382205