Let's try it a different way. Open Excel and in cell A1, right-click and choose paste. Now go up and click where the label is for column D and just column D should be blue. Now go up to Data/Text to Columns. This brings up the text to columns wizard. With the dot in Delimited click next. Put a checkmark in the commas box and click finish. You should now have each stock symbol in a different cell. To resize the cells go up to the grey box above row 1 and left of Column A and click it. This selects the whole sheet. Now place your mouse on the line between columns A & B or between Rows 1 & 2 and double-click and the columns and rows should autosize to fit the data in them.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.