Hi all
sorry if this is a repeated question in this ng. I just could not find one
related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the word
"image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim

try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not find one
related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not find
one related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

Tim,
I, for one, will not be able to be of any further assistance when you insist
on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not find
one related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

Sorry
its not me. I went to this ng 24hourhelpdesk. and they really mind it when I
posted like this on the top. they sent me this long list of ng etiquettes
and stuff where they insisted on bottom posting to keep the flow of post in
ascending order. you know what i mean. to be honest i hate it too.
:)

these days you just don't know who says what. but I still try to do my best
to keep everybody happy. All I can say is sorry again. :)

tim


"Don Guillett" wrote in message
...
Tim,
I, for one, will not be able to be of any further assistance when you
insist on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not find
one related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

Tim

In these Excel news groups the preferred method is to top post.

Many other news groups get all bent out of shape with top posting.

There have been countless wars over this issue.

If you prefer bottom-posting then I guess you will learn to live without Don's
assistance.

Others will undoubtedly ignore the top or bottom posting and assist in either
case.


Gord Dibben MS Excel MVP

On Sun, 22 Jul 2007 20:11:09 GMT, "tim" wrote:

Sorry
its not me. I went to this ng 24hourhelpdesk. and they really mind it when I
posted like this on the top. they sent me this long list of ng etiquettes
and stuff where they insisted on bottom posting to keep the flow of post in
ascending order. you know what i mean. to be honest i hate it too.
:)

these days you just don't know who says what. but I still try to do my best
to keep everybody happy. All I can say is sorry again. :)

tim


"Don Guillett" wrote in message
...
Tim,
I, for one, will not be able to be of any further assistance when you
insist on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not find
one related my querry.

I have sitmap list in excel. I want to separate the links with the word
images in it.

http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

Point noted :)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tim

In these Excel news groups the preferred method is to top post.

Many other news groups get all bent out of shape with top posting.

There have been countless wars over this issue.

If you prefer bottom-posting then I guess you will learn to live without
Don's
assistance.

Others will undoubtedly ignore the top or bottom posting and assist in
either
case.


Gord Dibben MS Excel MVP

On Sun, 22 Jul 2007 20:11:09 GMT, "tim"
wrote:

Sorry
its not me. I went to this ng 24hourhelpdesk. and they really mind it when
I
posted like this on the top. they sent me this long list of ng etiquettes
and stuff where they insisted on bottom posting to keep the flow of post
in
ascending order. you know what i mean. to be honest i hate it too.
:)

these days you just don't know who says what. but I still try to do my
best
to keep everybody happy. All I can say is sorry again. :)

tim


"Don Guillett" wrote in message
...
Tim,
I, for one, will not be able to be of any further assistance when you
insist on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not
find
one related my querry.

I have sitmap list in excel. I want to separate the links with the
word
images in it.


http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with
the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

I don't think it is that black and white, if you do bottom postings you need
to trim the post so it doesn't take like 3 pages to get to it.


--

Regards,

Peo Sjoblom

"tim" wrote in message
...
Point noted :)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tim

In these Excel news groups the preferred method is to top post.

Many other news groups get all bent out of shape with top posting.

There have been countless wars over this issue.

If you prefer bottom-posting then I guess you will learn to live without
Don's
assistance.

Others will undoubtedly ignore the top or bottom posting and assist in
either
case.


Gord Dibben MS Excel MVP

On Sun, 22 Jul 2007 20:11:09 GMT, "tim"
wrote:

Sorry
its not me. I went to this ng 24hourhelpdesk. and they really mind it
when I
posted like this on the top. they sent me this long list of ng etiquettes
and stuff where they insisted on bottom posting to keep the flow of post
in
ascending order. you know what i mean. to be honest i hate it too.
:)

these days you just don't know who says what. but I still try to do my
best
to keep everybody happy. All I can say is sorry again. :)

tim


"Don Guillett" wrote in message
.. .
Tim,
I, for one, will not be able to be of any further assistance when you
insist on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not
find
one related my querry.

I have sitmap list in excel. I want to separate the links with the
word
images in it.


http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with
the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

I cast my vote for 'top posting' also, but somehow I manage to deal with
those who choose (or are directed) to do otherwise :) But it really does
make more sense (to me) to have the latest at the top - makes it easier for
me to read the history, and if I need to go all the way back to the
beginning, I'll do so when required. Besides, it's a lot quicker to figure
out that a problem is solved when we see "thanks, it worked" at the very top
of a post rather than having to scroll to the very deepest pits of hades to
find out that the problem has been taken care of. Not picking at or on you
at all - I realize you were directed to do as you did, but you might want to
take some of these comments back to that 24hourhelpdesk with a hefty dose of
"take that!! helpdeskweenie!!!" <g

"tim" wrote:

Point noted :)

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tim

In these Excel news groups the preferred method is to top post.

Many other news groups get all bent out of shape with top posting.

There have been countless wars over this issue.

If you prefer bottom-posting then I guess you will learn to live without
Don's
assistance.

Others will undoubtedly ignore the top or bottom posting and assist in
either
case.


Gord Dibben MS Excel MVP

On Sun, 22 Jul 2007 20:11:09 GMT, "tim"
wrote:

Sorry
its not me. I went to this ng 24hourhelpdesk. and they really mind it when
I
posted like this on the top. they sent me this long list of ng etiquettes
and stuff where they insisted on bottom posting to keep the flow of post
in
ascending order. you know what i mean. to be honest i hate it too.
:)

these days you just don't know who says what. but I still try to do my
best
to keep everybody happy. All I can say is sorry again. :)

tim


"Don Guillett" wrote in message
...
Tim,
I, for one, will not be able to be of any further assistance when you
insist on bottom posting.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...

"Don Guillett" wrote in message
...
try
=IF(FIND("image",B2),B2,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"tim" wrote in message
...
Hi all
sorry if this is a repeated question in this ng. I just could not
find
one related my querry.

I have sitmap list in excel. I want to separate the links with the
word
images in it.


http://.........../display.asp?hs=71...xnetflext35.18
http://............/display.asp?image=large&hs=7130g

both links are in B1 and B2, I want to copy the the link with
the
word "image" in the middle to A2. what formula can I use in A2?

any tip would be appreciated.
Thanks in advance.
tim







Thanks
it works.
tim

I believe it depends on several factors, bottom posting is the format used
by newsgroups since the beginning, however it should be trimmed, it doesn't
make sense to have to plough through pages of stuff to find 2 lines at the
bottom.. It also depends on the newsreader, OE is not a very good
newsreader, in fact it is terrible as a text editor but it might be easier
to top post if you use it (I use it with all of its drawbacks because I got
so used to it that when I tried better readers I never got past the learning
stage). One thing I don't understand is how people can use the CDO unless
they have no choice?


--
Regards,

Peo Sjoblom





"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I cast my vote for 'top posting' also, but somehow I manage to deal with
those who choose (or are directed) to do otherwise :) But it really does
make more sense (to me) to have the latest at the top - makes it easier
for
me to read the history, and if I need to go all the way back to the
beginning, I'll do so when required. Besides, it's a lot quicker to
figure
out that a problem is solved when we see "thanks, it worked" at the very
top
of a post rather than having to scroll to the very deepest pits of hades
to
find out that the problem has been taken care of. Not picking at or on
you
at all - I realize you were directed to do as you did, but you might want
to
take some of these comments back to that 24hourhelpdesk with a hefty dose
of
"take that!! helpdeskweenie!!!" <g

"tim" wrote:

I do think that posters should "do as the Romans do". Here, it's top
posting. I had helped this poster a couple of times, each requesting top
posting. So, he says thanks by bottom posting.................
Arrrrrrrrrrrrrg! I need to learn to be more patient.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peo Sjoblom" wrote in message
...
I believe it depends on several factors, bottom posting is the format used
by newsgroups since the beginning, however it should be trimmed, it doesn't
make sense to have to plough through pages of stuff to find 2 lines at the
bottom.. It also depends on the newsreader, OE is not a very good
newsreader, in fact it is terrible as a text editor but it might be easier
to top post if you use it (I use it with all of its drawbacks because I got
so used to it that when I tried better readers I never got past the
learning stage). One thing I don't understand is how people can use the
CDO unless they have no choice?


--
Regards,

Peo Sjoblom





"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I cast my vote for 'top posting' also, but somehow I manage to deal with
those who choose (or are directed) to do otherwise :) But it really does
make more sense (to me) to have the latest at the top - makes it easier
for
me to read the history, and if I need to go all the way back to the
beginning, I'll do so when required. Besides, it's a lot quicker to
figure
out that a problem is solved when we see "thanks, it worked" at the very
top
of a post rather than having to scroll to the very deepest pits of hades
to
find out that the problem has been taken care of. Not picking at or on
you
at all - I realize you were directed to do as you did, but you might want
to
take some of these comments back to that 24hourhelpdesk with a hefty dose
of
"take that!! helpdeskweenie!!!" <g

"tim" wrote:

Well, for whatever it's worth, I tend to agree with Peo's "when in Rome,
light Roman Candles". But I also see the problem of a new-to-groups (which
in truth, I am also) person in learning/being told to do it one way here,
another way there, and just stay home and watch it rain somewhere else. Hard
to remember everyone else's rules - especially since they are their! rules,
not mine. And I'm quick to point that out to places I may go (as in
brick-and-mortar stores) and they tell me "well, OUR rule is..." and I say
"key word here is "OUR" not MINE and I don't get paid to remember YOUR rules
:( " Ya'Know what I mean?

"Don Guillett" wrote:

I do think that posters should "do as the Romans do". Here, it's top
posting. I had helped this poster a couple of times, each requesting top
posting. So, he says thanks by bottom posting.................
Arrrrrrrrrrrrrg! I need to learn to be more patient.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peo Sjoblom" wrote in message
...
I believe it depends on several factors, bottom posting is the format used
by newsgroups since the beginning, however it should be trimmed, it doesn't
make sense to have to plough through pages of stuff to find 2 lines at the
bottom.. It also depends on the newsreader, OE is not a very good
newsreader, in fact it is terrible as a text editor but it might be easier
to top post if you use it (I use it with all of its drawbacks because I got
so used to it that when I tried better readers I never got past the
learning stage). One thing I don't understand is how people can use the
CDO unless they have no choice?


--
Regards,

Peo Sjoblom





"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I cast my vote for 'top posting' also, but somehow I manage to deal with
those who choose (or are directed) to do otherwise :) But it really does
make more sense (to me) to have the latest at the top - makes it easier
for
me to read the history, and if I need to go all the way back to the
beginning, I'll do so when required. Besides, it's a lot quicker to
figure
out that a problem is solved when we see "thanks, it worked" at the very
top
of a post rather than having to scroll to the very deepest pits of hades
to
find out that the problem has been taken care of. Not picking at or on
you
at all - I realize you were directed to do as you did, but you might want
to
take some of these comments back to that 24hourhelpdesk with a hefty dose
of
"take that!! helpdeskweenie!!!" <g

"tim" wrote:

That's a bit different. Here you need to use the golden rule.
"The man with the gold make the rule"!!


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Well, for whatever it's worth, I tend to agree with Peo's "when in Rome,
light Roman Candles". But I also see the problem of a new-to-groups
(which
in truth, I am also) person in learning/being told to do it one way here,
another way there, and just stay home and watch it rain somewhere else.
Hard
to remember everyone else's rules - especially since they are their!
rules,
not mine. And I'm quick to point that out to places I may go (as in
brick-and-mortar stores) and they tell me "well, OUR rule is..." and I say
"key word here is "OUR" not MINE and I don't get paid to remember YOUR
rules
:( " Ya'Know what I mean?

"Don Guillett" wrote:

I do think that posters should "do as the Romans do". Here, it's top
posting. I had helped this poster a couple of times, each requesting top
posting. So, he says thanks by bottom posting.................
Arrrrrrrrrrrrrg! I need to learn to be more patient.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Peo Sjoblom" wrote in message
...
I believe it depends on several factors, bottom posting is the format
used
by newsgroups since the beginning, however it should be trimmed, it
doesn't
make sense to have to plough through pages of stuff to find 2 lines at
the
bottom.. It also depends on the newsreader, OE is not a very good
newsreader, in fact it is terrible as a text editor but it might be
easier
to top post if you use it (I use it with all of its drawbacks because I
got
so used to it that when I tried better readers I never got past the
learning stage). One thing I don't understand is how people can use the
CDO unless they have no choice?


--
Regards,

Peo Sjoblom





"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
I cast my vote for 'top posting' also, but somehow I manage to deal
with
those who choose (or are directed) to do otherwise :) But it really
does
make more sense (to me) to have the latest at the top - makes it
easier
for
me to read the history, and if I need to go all the way back to the
beginning, I'll do so when required. Besides, it's a lot quicker to
figure
out that a problem is solved when we see "thanks, it worked" at the
very
top
of a post rather than having to scroll to the very deepest pits of
hades
to
find out that the problem has been taken care of. Not picking at or
on
you
at all - I realize you were directed to do as you did, but you might
want
to
take some of these comments back to that 24hourhelpdesk with a hefty
dose
of
"take that!! helpdeskweenie!!!" <g

"tim" wrote:

The snipping of unnecessary stuff is a good idea.

Leave enough so the thread can be understood, but no more.

Then Top Post


Gord

On Mon, 23 Jul 2007 08:44:17 -0700, "Peo Sjoblom" wrote:

I believe it depends on several factors, bottom posting is the format used
by newsgroups since the beginning, however it should be trimmed, it doesn't
make sense to have to plough through pages of stuff to find 2 lines at the
bottom.. It also depends on the newsreader, OE is not a very good
newsreader, in fact it is terrible as a text editor but it might be easier
to top post if you use it (I use it with all of its drawbacks because I got
so used to it that when I tried better readers I never got past the learning
stage). One thing I don't understand is how people can use the CDO unless
they have no choice?