|
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
"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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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 |
Need Formula Help Copying "Image" URL from B2 to A2
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: |
Need Formula Help Copying "Image" URL from B2 to A2
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: |
Need Formula Help Copying "Image" URL from B2 to A2
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: |
Need Formula Help Copying "Image" URL from B2 to A2
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: |
Need Formula Help Copying "Image" URL from B2 to A2
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? |
| All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com