How can I copy paste the yahoo earnings chart information into a spreadsheet so as to separate just the symbol

Question

so I can create my own porfolios without hand typing each symbol?

Answer 1

Text to columns will allow you to split the contents of a cell or if the symbol is the first character in the cell try =left(cell,1) or for the last character =right(cell,1).