find cells that contain specific characters

mshornet · External Since: Nov 19, 2005 Posts: 5

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

Roland · External Since: Nov 07, 2004 Posts: 62

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?

mshornet · External Since: Nov 19, 2005 Posts: 5

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?

Biff · External Since: Dec 09, 2004 Posts: 3582

Hi!

What does: "pull them out of a long line of cells" mean?

Can you provide some examples?

Biff

"mshornet" <mshornet DeleteThis @discussions.microsoft.com> wrote in message
news:9B258D7B-8318-40EC-89F8-7FD8F1E32F26@microsoft.com...
> How do I find cells that contain specific characters and pull them out of
> a
> long line of cells?

mshornet · External Since: Nov 19, 2005 Posts: 5

Thanks for your reply. What I would like to do is search a column of cells
and contain text. Some of the cells contain the letters "vo". Others do
not. I want to select those cells that contain "vo" and copy them to another
column.

"Biff" wrote:

> Hi!
>
> What does: "pull them out of a long line of cells" mean?
>
> Can you provide some examples?
>
> Biff
>
> "mshornet" <mshornet.RemoveThis@discussions.microsoft.com> wrote in message
> news:9B258D7B-8318-40EC-89F8-7FD8F1E32F26@microsoft.com...
> > How do I find cells that contain specific characters and pull them out of
> > a
> > long line of cells?
>
>
>

Gord Dibben · External Since: Feb 23, 2004 Posts: 9167

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.RemoveThis@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?

Biff · External Since: Dec 09, 2004 Posts: 3582

Hi!

The easiest way:

Assume the data is in the range A2:A100, A1 is the column header.

Select cell A1
Goto Data>Filter>AutoFilter
Click the arrow that appears in cell A1
Select CUSTOM
From the drop down that says EQUALS, select CONTAINS
In the box to the right enter: vo
Click OK.

Do your copy/paste

Then turn off the filter:

Data >Filter>AutoFilter (selecting AutoFilter toggles it on or off)

Biff

"mshornet" <mshornet.DeleteThis@discussions.microsoft.com> wrote in message
news:F56A7B0E-8A70-4E2A-B280-20BD5FAF8573@microsoft.com...
> Thanks for your reply. What I would like to do is search a column of
> cells
> and contain text. Some of the cells contain the letters "vo". Others do
> not. I want to select those cells that contain "vo" and copy them to
> another
> column.
>
> "Biff" wrote:
>
>> Hi!
>>
>> What does: "pull them out of a long line of cells" mean?
>>
>> Can you provide some examples?
>>
>> Biff
>>
>> "mshornet" <mshornet.DeleteThis@discussions.microsoft.com> wrote in message
>> news:9B258D7B-8318-40EC-89F8-7FD8F1E32F26@microsoft.com...
>> > How do I find cells that contain specific characters and pull them out
>> > of
>> > a
>> > long line of cells?
>>
>>
>>

mshornet · External Since: Nov 19, 2005 Posts: 5

Thank you. Sorry for my slow response. Thanks again.

"Biff" wrote:

> Hi!
>
> The easiest way:
>
> Assume the data is in the range A2:A100, A1 is the column header.
>
> Select cell A1
> Goto Data>Filter>AutoFilter
> Click the arrow that appears in cell A1
> Select CUSTOM
> From the drop down that says EQUALS, select CONTAINS
> In the box to the right enter: vo
> Click OK.
>
> Do your copy/paste
>
> Then turn off the filter:
>
> Data >Filter>AutoFilter (selecting AutoFilter toggles it on or off)
>
> Biff
>
> "mshornet" <mshornet.RemoveThis@discussions.microsoft.com> wrote in message
> news:F56A7B0E-8A70-4E2A-B280-20BD5FAF8573@microsoft.com...
> > Thanks for your reply. What I would like to do is search a column of
> > cells
> > and contain text. Some of the cells contain the letters "vo". Others do
> > not. I want to select those cells that contain "vo" and copy them to
> > another
> > column.
> >
> > "Biff" wrote:
> >
> >> Hi!
> >>
> >> What does: "pull them out of a long line of cells" mean?
> >>
> >> Can you provide some examples?
> >>
> >> Biff
> >>
> >> "mshornet" <mshornet.RemoveThis@discussions.microsoft.com> wrote in message
> >> news:9B258D7B-8318-40EC-89F8-7FD8F1E32F26@microsoft.com...
> >> > How do I find cells that contain specific characters and pull them out
> >> > of
> >> > a
> >> > long line of cells?
> >>
> >>
> >>
>
>
>

mshornet · External Since: Nov 19, 2005 Posts: 5

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.RemoveThis@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?
>
>