Extracting an exact phrase from a Cell

M

mazalam

:eek: :confused:

I have column A with 600 entries of Text such as:

Invalid cfg: DIMXPS-G3 REQUIRES MG MONITOR >= 1



Some cells would say "MONITOR" some would say "Keyboard" and some woul
say "Speakers".


How can I extract entries with only Monitor in the text
 
I

ilanr01

mazalam said:
:eek: :confused:

I have column A with 600 entries of Text such as:

Invalid cfg: DIMXPS-G3 REQUIRES MG MONITOR >= 1



Some cells would say "MONITOR" some would say "Keyboard" and some would
say "Speakers".


How can I extract entries with only Monitor in the text?
Click to expand...

Use Data\autofilter onyour range and filter using Custom\contains
MONITOR
Ilan
 
M

mazalam

ilanr01 said:
Use Data\autofilter onyour range and filter using Custom\contain
MONITOR
Ilan
Click to expand...

What version of Excel does that? I can only see "Data" then "Filter
and then two options:
Auto Filter
Advanced Filte
 
D

Dave Peterson

Select your range (all the range--not just a column or two).

Then apply
Data|filter|autofilter

You'll see that the top row in each column in that selection has a dropdown
arrow in it.

You can use that dropdown to show just the stuff you want to see.

There's an option in that dropdown list called "custom".
Choose that
scroll down the list until you see Contains
type in Monitor
click ok

And tada, you only see the rows that have Monitor in that column.

If you wanted, you could select those visible rows and copy them. Then paste
them into a new worksheet.

Debra Dalgleish has some nice instructions at:
http://contextures.com/xlautofilter01.html
 
Top