Thanks. Sorry for my slow reply. Thanks again.
"Gord Dibben" wrote:
> Data>Filter>Autofilter
>
> Filter on VO then copy those cells to another column.
>
>
> Gord Dibben Excel MVP
>
> On Sat, 19 Nov 2005 19:09:02 -0800, "mshornet"
> <mshornet@discussions.microsoft.com> 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?
>
>
Bookmarks