Could you show me the data which failed to extract? then i'll try to check
it out.

keizi

"CompleteNewb" wrote in message
. ..
kounoike:

Worked like a dream, and a hearty thanks to you. Mr. Phillips, yours
seemed to work also, and I grealy appreciate your help. For some reason
your approach skipped over 3 consecutive values out of 700, and I'm
fiddling around trying to investigate the cause. I thought maybe it was
because of apostrophes in the values in Column A, but it handled other
values with apostrophes fine.