I'm transferring infomation (copying and pasting) from a website to Excel. Two of the columns have hyperlinks that transfer over into the data. The information is coming over with a heading over an empty column space between each column with data - that is, the column headings above an empty column and the column information pasting into the column beside it. I am deleting the first column between A2 and wherever to drag the information under the specific column heading, but I'm still left with all these empty columns inbetween the information..........
So, two questions.........is there a way to remove hyperlinks en masse with the first two columns of information rather than go in and remove each and every one separately?
And a way to remove the empty columns from the information en masse as well?
So, two questions.........is there a way to remove hyperlinks en masse with the first two columns of information rather than go in and remove each and every one separately?
And a way to remove the empty columns from the information en masse as well?
