| 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 |
|
#4
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.
|
| 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 | |||
Hybrid Mode
