Simple Excel Question - Need help!

[A D]

Ok, so let's say I have a list of 1000 domains and I want to find all the domains with the word 'girl' in them. So I do a find all and it finds the cells.

How the heck do I copy just those ones out of the sheet I am working on so I can use them in another?

I would ideally like to cut them from the main sheet and add them to another.

I will gladly buy an addon to do this if anyone knows of one.

Seems simple enough but can't figure it out.

Thanks in advance for solution.

==================================

BTW, I found this that doesn't solve my issues but works for other cool stuff.

http://www.sobolsoft.com/excelsortby/

This tool will allow you to take a list of domains and sort them by anything, the most useful for me has been by character count.

-=DCG=-

 

[BidNo]

You'll need to use an "Advanced Filter". Assuming you're on Excel 2007 this is under the "Data" tab, near the middle.

First enter your criteria to a cell so that you can then reference in your filter. A filter criteria for text containing a string is like "*string*" (without quotes and where "string" is your desired text). Excel is insensitive to letter case. You can either specify "Filter in place" or a different location for results.

Here's some decent step by step instructions, http://www.excelfunctions.net/ExcelAdvancedFilter.html. Only strange thing I noted was it seems you must have a title on your criteria for things to work.

Post back if you need more.

 

[Theo]

First select all the domains in the spreadsheet, then hit CTRL-F to enter the search string.

Then click on the *results* panel, and hit CTRL-A to select all.

Careful now

Move away from the results window and click on the top part of the main Excel panel - the toolbar. Do NOT click inside the spreadsheet!

Hit CTRL-C, then click on the "New Sheet" tab at the bottom.

Click inside a cell of the new sheet and hit CTRL-V to paste.

 

[tekz999]

http://auths.com/namesort.html

Bandwidth on me.

Enjoy.

 

[A D]

Acro, That worked.

Now is there a way to delete the chosen cells from the main list.

What I am trying to do is trim down the master list after I have taken some out to target based on major keywords.

Thanks tekz and bidno as well.

thanks,

-=DCG=-

 

[denny007]

Say domains are in column A
I would in cell B1 write
=FIND("girl",A1)
Paste to B2:B1000
Sort by column B
Any domain containing string "girl" will show a numerical value, otherwise it will show string "#VALUE!"

 

[visine]

An alternate method (assuming your master list is in a column):

STEP 1 - COPY LIST
- copy the entire column and insert a copy directly beside it
- make sure to keep the newly inserted column highlighted

STEP 2 - REPLACE
- select Edit--> Replace;
- in the Find what: enter *girl*
- in the Replace with: enter 1
- hit Replace All

STEP 3 - SORT
- highlight both columns (making sure the 1st column you select is the 'newly inserted' column)
- click sort (the A/Z sort button - see illustration below)
- all your 'girl' names should now be at the top of the list


A |
Z v


Steve

 

[Bionic]

http://auths.com/namesort.html

Bandwidth on me.

Enjoy.

Code by me! :smilewinkgrin:

http://www.freewebs.com/namesort/