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