Hi,

Suppose the data above is range B4:B8. In range B3, type any heading, say
Strings. In cell B10, type criteria and in B11, enter the following formula
=FIND("xyz",B4,1).

Now go the Data Filter Advanced Filter and select the radio button for
"Copy to another location". In the list range, select B3:B8 and in the
criteria range select B10:B11. In copy to, select any blank cell. Now
click on OK.

Please rememeber that this is not a dynamic solution I.e. if you change any
entries in B4:B8, the result will not automatically change. You will have
to rerun the advanced filter

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Yossy" wrote in message
...
How do I find certain values in a cells
E.g I want to find values that contain xyz and bring out only values that
contain xyz out in another column, the content are not in order and they
could come in any way. All help totally appreciated. Thanks
col a
what_xyz_123
xyz_thursday_under_im
my_klm_ply
dhyxyz_plum
mukl_p123_fjluy_na_dy_xyz

The result needed.
what_xyz_123
xyz_thursday_under_im
dhyxyz_plum
mukl_p123_fjluy_na_dy_xyz