Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
I Want to extract below info from urls given below.how can i do that in excel. kindly help.
AXIS-IT 532395 AXLESINDIA 40001 http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001 --Vishy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
On Monday, March 5, 2012 6:02:01 PM UTC+5:30, wrote:
I Want to extract below info from urls given below.how can i do that in excel. kindly help. AXIS-IT&T 532395 AXLESINDIA 40001 http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001 --Vishy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
On Monday, March 5, 2012 6:32:01 AM UTC-6, wrote:
I Want to extract below info from urls given below.how can i do that in excel. kindly help. AXIS-IT 532395 AXLESINDIA 40001 http://www.pppppppppp.com/bse/bsesha...-IT&T&c=532395 http://www.pppppppppp.com/bse/bsesha...SINDIA&c=40001 --Vishy With a formula, use FIND to locate the "=" and the "http" AFTER the first find. Then use MID 1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
will u post full formula to extract requested data.
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
Thanks a lot Claus Busch.. it is working but extracted data is like below in single cell.
AXIS-IT T 532395 (Note: & is missed between T&T.) Can we get extracted data like below in 2 different cells where as first cell containts 9 character string & 2nd cell contain 6 character numerical data. (note: we should able to extract sepecial charecters as well.) AXIS-IT&T 532395 ---Vishy |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
Hi Vishy,
Am Mon, 5 Mar 2012 05:21:38 -0800 (PST) schrieb : Thanks a lot Claus Busch.. it is working but extracted data is like below in single cell. AXIS-IT T 532395 (Note: & is missed between T&T.) try: =SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ") Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
Hi,
Am Mon, 5 Mar 2012 14:47:05 +0100 schrieb Claus Busch: =SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ") and then Data = Text to Columns and space as seperator Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
Working....Thanks a lot Claus Busch.
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting Text between 2 special characters of URL using Excel
On Monday, March 5, 2012 8:35:30 PM UTC+5:30, wrote:
Working....Thanks a lot Claus Busch. Hi Claus Busch plz check another post of mine ie "How should i call below function" in this forum. i want to download multiple no of zip files from internet based on range of dates.so i found one function ie URLDownloadToFile() while googling & i tried the same @ my end,but no progress on it. kindly check that post & let me know how should i use that function. Thanks in Adv. Regards Vishy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract all text without spaces and special characters | Excel Worksheet Functions | |||
Importing Text files w/o losing special characters | Excel Programming | |||
Excel Save As... text with special characters | Excel Discussion (Misc queries) | |||
REMOVE SPECIAL CHARACTERS FROM TEXT CELLS | Excel Worksheet Functions | |||
Convert text with special characters | Excel Programming |