extracting cells (words) from excel column

[rneedham]

I have a huge list of words in a txt file.. i transfered them to a exce
spreadsheet. all words are on there own line.
i need to extract all words which have "apple" in the word.
I tryed going through the sorting mechanism of excel but cannot seem t
find the right function. I thought "text to column" was the right on
but found you can't enter specific words.

rya

 

[Niek Otten]

Hi Ryan,

Introduce a helper column. If your data is in Col A, then Col B should be
something like

=IF(ISERROR(FIND("apple",A1)),"","*")

After Copying and Paste Special>Values you can sort or otherwise manipulate
the data any way you want.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Robert Rosenberg]

Try using the AutoFilter feature...

1. Make sure each column in your list has a heading at the top. For example,
if a list has a column of last names, I'd add a column heading called "Last
Name" just above the first entry in that column.

2. Click anywhere in your list

3. Click Data-->Filter-->AutoFilter
You should now see a dropdown next to each column heading in your list

4. Click the dropdown arrow next to the desired column heading and choose
"(Custom...)" on the list

5. In the dialog that appears, change the first dropdown to "contains" and
type the desired word in the dropdown/textbox to the right (ex: apple)

6. Click OK

--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com

 

[rneedham]

thanks.. both methods worked nicely.

ryan