Thanks. Sorry for my slow reply. Thanks again.

"Gord Dibben" wrote:

DataFilterAutofilter

Filter on VO then copy those cells to another column.


Gord Dibben Excel MVP

On Sat, 19 Nov 2005 19:09:02 -0800, "mshornet"
wrote:

Thanks. I should explain my problem better. I have a long column of cells
that contain text. Some of these cells have the characters "VO" in them. I
want to find those cells and make a new column of cells with only those cells
that contained "VO" in them.

"Roland" wrote:

Try using the funtionality found from the main menu Edit Find.

"mshornet" wrote:

How do I find cells that contain specific characters and pull them out of a
long line of cells?