Thread
:
macro - delete row if cell contains string
View Single Post
#
9
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 6,953
macro - delete row if cell contains string
How do you read it?
a
a/b
c/d
e
e/f
delete everything but c/d as I understood it.
--
Regards,
Tom Ogilvy
"Dave Peterson" wrote:
You could use a helper column with formulas like:
=isnumber(search("/",a2))
Then drag it down the column.
Then apply data|filter|autofilter to that column.
Show the Trues and delete those visible rows.
wrote:
Hi all,
Can some one help me please!
Here is a slightly more complex macro that I really need. I have a list
of domain names in excel for example:
1
www.throneofnails.com
2
www.throneofnails.com/info/index.html
3
www.fairkess.com/en/business/industrie.html
4
www.endlessdecor.com/Links.html
5
www.retractableawnings.com/resources.htm
6
www.ffbd-tm.com
7
www.ffbd-tm.com/test
I need a macro that will delete all the top level domain names eg
www.throneofnails.com
and delete all files in that domain eg
www.throneofnails.com/info/index.html
.
I need to be left with a list of only domain names like domain name 3,4
and 5.
I think it will probably have something to do with finding the cells
that dont contain a "/" then loading them into an array then deleting
all cells that contain the contents of that array.
Unfortunately I dont have the programing language to do this.
Your help would be much appreciated.
Many thanks
Alex Kemsley
--
Dave Peterson
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy