"Joe" wrote in message
ups.com...
Thanks for the qns. More on those:

1. The columns A:D are being copied from a daily report by another
macro in the same module into this worksheet.This parent report is
generated daily by an archaic database program.

(The entries in column D have to be split so that I can do an exact
match comparison against another excel spreadsheet column) Which is
also the reason why I dont have any control over the entries, or the
order in which they occur.

2. Yes, I put the quotes in the message - there are no quotation marks
in the actual text.

Please feel free to post any more questions, if you have any. i really
appreciate your time and consideration.

Thanks,

Joe.


Which archaic database program is producing the data? I'm asking because no
matter how archaic, many database apps allow the creation of custom reports.
You can design the reports to use certain symbols to delimit (separate) one
field (column) from another.