| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically adding image extension ".jpg" to end of image name | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Copying a formula "literally" | Excel Discussion (Misc queries) | |||
Hybrid Mode
