find cells that contain specific characters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mshornet - 19 Nov 2005 23:56 GMT

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

Reply to this Message

Biff - 20 Nov 2005 00:37 GMT

Hi!

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

Can you provide some examples?

Biff

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

Reply to this Message

mshornet - 20 Nov 2005 03:04 GMT

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.

> Hi!
>
[quoted text clipped - 7 lines]
> > a
> > long line of cells?

Reply to this Message

Biff - 20 Nov 2005 03:24 GMT

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

> Thanks for your reply. What I would like to do is search a column of
> cells
[quoted text clipped - 15 lines]
>> > a
>> > long line of cells?

Reply to this Message

mshornet - 23 Nov 2005 14:02 GMT

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

> Hi!
>
[quoted text clipped - 37 lines]
> >> > a
> >> > long line of cells?

Reply to this Message

Roland - 20 Nov 2005 01:04 GMT

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

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

Reply to this Message

mshornet - 20 Nov 2005 03:09 GMT

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.

> Try using the funtionality found from the main menu Edit > Find.
>
> > How do I find cells that contain specific characters and pull them out of a
> > long line of cells?

Reply to this Message

Gord Dibben - 20 Nov 2005 03:38 GMT

Data>Filter>Autofilter

Filter on VO then copy those cells to another column.

Gord Dibben Excel MVP

>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
[quoted text clipped - 5 lines]
>> > How do I find cells that contain specific characters and pull them out of a
>> > long line of cells?

Reply to this Message

mshornet - 23 Nov 2005 14:02 GMT

Thanks. Sorry for my slow reply. Thanks again.

> Data>Filter>Autofilter
>
[quoted text clipped - 11 lines]
> >> > How do I find cells that contain specific characters and pull them out of a
> >> > long line of cells?

Reply to this Message