Grabbing info from 1 col to another ?

[davidstokes]

Hi

1st time here.. I never know about this place

I have a excel file with about 10000 lines of info in COL A,

This info is domain names,, But what i need to do is pull all the domains with a word in it into a new col.

So lets say i want all domains with the work "Design" in them in COL B

I would get domains like

webdesign.com
yourdesign.info
letsdesign.net
designyourcar.com

and so on,

Can this be done in excel ?...

See my boss has a new idea and I'll be getting lists like this everyday (some as big as 50000) and I've to filter out the domains he wants into catergorys he asks.... Would take me a long time.

Any help would be great

Cheers

[Ron Coderre]

Try using an Advanced Filter...

With
A1: DomainName...(this is just a column title)
A2:A50000 contains domain names

B1: DomainName...(must be the same title as A1)

C1: DomainName...(Also must match the A1 title)
C2: *Design*....(or whatever text you want to match...the asterisks are wildcards)

Then...from the Excel Main Menu:
Data.Filter.Advanced_Filter
Check: Copy to another location
List Range: $A$1:$A$5000
Criteria Range: $C$1:$C$2
Copy to: $B$1
Click: OK

The domain names that contain the word "design" will be listed under B1.
Search Excel Help for "advanced filter" for more information.

Is that something you can work with?

[JethroUK]

XL has built-in filter for this

Select the cell immediately above your data (add a row if ness)

Choose Data>Filter>Auto Filter

Click the filter and choose "custom"

Show rows where:

"Contains" 'design'

[davidstokes]

XL has built-in filter for this

Select the cell immediately above your data (add a row if ness)

Choose Data>Filter>Auto Filter

Click the filter and choose "custom"

Show rows where:

"Contains" 'design'

Anytime i try this i just get nothing,, all the other domain dissapear.. I select "All" again and they reappear.. Do i set other settings in the auto filter pop up ?

[davidstokes]

Try using an Advanced Filter...

With
A1: DomainName...(this is just a column title)
A2:A50000 contains domain names

B1: DomainName...(must be the same title as A1)

C1: DomainName...(Also must match the A1 title)
C2: *Design*....(or whatever text you want to match...the asterisks are wildcards)

Then...from the Excel Main Menu:
Data.Filter.Advanced_Filter
Check: Copy to another location
List Range: $A$1:$A$5000
Criteria Range: $C$1:$C$2
Copy to: $B$1
Click: OK

The domain names that contain the word "design" will be listed under B1.
Search Excel Help for "advanced filter" for more information.

Is that something you can work with?

I got this one working thanks.

[djmetsandy]

The autofilter would make the domain names with the key word in them disappear - that is the purpose of the filter. The only data that will stay is the data you are looking for.