Extracting Text between 2 special characters of URL using Excel

  • Thread starter Thread starter writetoevv
  • Start date Start date
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
 
Hi Vishy,

Am Mon, 5 Mar 2012 05:21:38 -0800 (PST) schrieb (e-mail address removed):
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.)
Click to expand...

try:
=SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ")


Regards
Claus Busch
 
Hi,

Am Mon, 5 Mar 2012 14:47:05 +0100 schrieb Claus Busch:
=SUBSTITUTE(MID(A1,FIND("=",A1)+1,99),"&c="," ")
Click to expand...

and then Data => Text to Columns and space as seperator


Regards
Claus Busch
 
Working....Thanks a lot Claus Busch.
Click to expand...

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
 
Back
Top