Hi,

1. Select the column of data.
2. Chooose Data, Filter, AutoFilter
3. Open the auto filter drop down and choose Custom, pick Contains from the
first drop down, enter xyz in the second box.
4. Select the results and copy and paste them to a new location.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Yossy" wrote:

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