Hi,
I am trying to copy data from a webpage but when pasted into excel, the formatting is incorrect. The first column has project names which are hyperlinks on the webpage. When copied into excel, the links break up into two rows. Ie. "Start-Up Online" would be like this:
row 6 Start-
row 7 Up Online
or Vendor Number expansion becomes:
row 8 Vendor Number
row 9 Expansion
How do I get excel to format this properly?
I am trying to copy data from a webpage but when pasted into excel, the formatting is incorrect. The first column has project names which are hyperlinks on the webpage. When copied into excel, the links break up into two rows. Ie. "Start-Up Online" would be like this:
row 6 Start-
row 7 Up Online
or Vendor Number expansion becomes:
row 8 Vendor Number
row 9 Expansion
How do I get excel to format this properly?
