Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extracting an exact phrase from a Cell
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? -- mazalam ------------------------------------------------------------------------ mazalam's Profile: http://www.excelforum.com/member.php...o&userid=26768 View this thread: http://www.excelforum.com/showthread...hreadid=401184 |
#2
|
|||
|
|||
What do you mean by extract? -- Dnereb ------------------------------------------------------------------------ Dnereb's Profile: http://www.excelforum.com/member.php...o&userid=26182 View this thread: http://www.excelforum.com/showthread...hreadid=401184 |
#3
|
|||
|
|||
mazalam Wrote: 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? Use Data\autofilter onyour range and filter using Custom\contains MONITOR Ilan -- ilanr01 ------------------------------------------------------------------------ ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797 View this thread: http://www.excelforum.com/showthread...hreadid=401184 |
#4
|
|||
|
|||
Dnereb Wrote: What do you mean by extract? I want to flag the adjacent column if the particular phrase, "Monitor", Spkrs etc, exist in Column A -- mazalam ------------------------------------------------------------------------ mazalam's Profile: http://www.excelforum.com/member.php...o&userid=26768 View this thread: http://www.excelforum.com/showthread...hreadid=401184 |
#5
|
|||
|
|||
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...o&userid=26768 View this thread: http://www.excelforum.com/showthread...hreadid=401184 |
#6
|
|||
|
|||
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 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...o&userid=26768 View this thread: http://www.excelforum.com/showthread...hreadid=401184 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
extracting text data in a cell | Excel Worksheet Functions | |||
up to 7 functions? | Excel Worksheet Functions | |||
Extracting names in a cell | Excel Discussion (Misc queries) | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |