Re: Extracting an exact phrase from a Cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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 work***.

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



mazalam wrote:
>
> ilanr01 Wrote:
> > Use Data\autofilter onyour range and filter using Custom\contains
> > MONITOR
> > Ilan
>
> What version of Excel does that? I can only see "Data" then "Filter"
> and then two options:
> Auto Filter
> Advanced Filter
>
> --
> mazalam
> ------------------------------------------------------------------------
> mazalam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26768
> View this thread: http://www.excelforum.com/showthread.php?threadid=401184

--

Dave Peterson
.

Quantcast