Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |