When I copy HTML data and use the paste options I get a choice of three
options. HTML, Unicode Text, Text. If I use the HTML option everyting goes in
the correct but I can not use the cell content in a formula. Both of the
other two options puts all data in the A column. A-1 copies to A-1, B-1 to
A-2, C-1 to A-3 etc. Data in these cells can be used in formulas. How can I
copy have all data where it belongs and use the data in a formula???