Hello

Thanks for replying. The macro can be real simple if there is number just appear 1 time in the whole beginning and ending of html tag. There are more than 1 numbers in the body of beginning and ending of the html tag, so the whatever is in title and /title has to be attached to those number to know as to which number belong to which records. Attached is the output file.

input file can be found below link it only 3 records but 48 pages of html data in word.

input data 1202.doc - Google Docs

also one of the things that complicates the macro, that sometime numbers have 3 format to extract as below.

(###) ###-####
(###)###-####
###-###-####

As you said there is a better way to do it, if it can be done without opening 3 windows that would be great.

Thanks a lot!!

Attached Files

output data 1202.doc (22.0 KB, 12 views)