find cells that contain specific characters

M

mshornet

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

Biff

Hi!

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

Can you provide some examples?

Biff
 
M

mshornet

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.
 
M

mshornet

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.
 
B

Biff

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
 
G

Gord Dibben

Data>Filter>Autofilter

Filter on VO then copy those cells to another column.


Gord Dibben Excel MVP
 
M

mshornet

Thanks. Sorry for my slow reply. Thanks again.

Gord Dibben said:
Data>Filter>Autofilter

Filter on VO then copy those cells to another column.


Gord Dibben Excel MVP
Click to expand...
 
Top