Thanks Mr sassora.
i dont get the answer because when i am trying to run ur programme i get the
all things in a single cell example

sheet2
A1=

"1 Doctor's Name
Lee N HAMMONTREE MD
[Are you Lee N HAMMONTREE MD? Register now and customize this page!]
Location
Alabama
(City : Birmingham)
(ZIP : 35294)
[More Suggested Doctors From Alabama]
Specialty
Urology

[More Suggested Urology Doctors ..]

[Other Urology Doctors From Alabama..]
Patient Recommendations


1
(0 complaints)

[Suggest This Doctor Now!]
Messages in Doctors Inbox
1
[Send a Message to This Doctor]
Search in Patient Reviews

[Advanced Search]

Lee N HAMMONTREE MD's Special Expertises :
Urology
Recommend Lee N HAMMONTREE MD

Major Activity


Doctor's Hospital
-

Doctor's Office
Office
Office Fot 1105 1530 3rd Ave S Birmingham 35294

Phone Number
Fax # :
(205) 9398939

Gender
Male

Medical School
Univ Of Tn, Memphis, Coll Of Med, Memphis Tn 38163

Graduation Year
1988
(25 years of experience)

Languages


Videos

Memories

Search Doctors within Tags
"


how can i extract from here?
thanks for ur valuable assistance