Thread: Extracting Text between 2 special characters of URL using Excel
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Extracting Text between 2 special characters of URL using Excel
Hi Vishy,

Am Mon, 5 Mar 2012 04:32:01 -0800 (PST) schrieb :

AXIS-IT 532395
AXLESINDIA 40001

http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001

URL in A1, then:
=SUBSTITUTE(SUBSTITUTE(MID(A1,FIND("=",A1)+1,99)," &"," "),"c=",)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote