View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
tim tim is offline
external usenet poster
 
Posts: 22
Default 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