Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Can anybody tell a me how I can load a large vertical list into the margin of a spreadsheet?

e.g, I want to copy a list of stocks from notepad (aligned vertically) to Google spreadsheet with each word in its own cell vertically down the left margin of a Google spreadsheet;

Also if I want to get the volume of all of these stocks in column A via a feed from Yahoo finance BUT wanted to do it in one line of code rather than add it stock by stock how can I do that ?

The inputs I have are price, price % change, volume, volume ave. I can do all of those individually but I'd like to be able to add the stocks to it in bulk quickly.

And that should be updated every 20 minutes right?

share|improve this question

2 Answers 2

With the following formula you can convert a comma-separated cell into a column range:

A1=tom,cat,jake,jil,mike
A2=TRANSPOSE(SPLIT(A1;","))
share|improve this answer

This site doesn't work well when you load up a Question with multiple questions.

As for your first question, I would save the file with a .csv extension then upload it to Google Drive with the "convert" option checked. Assuming you have your items on separate lines it should convert nicely into a spreadsheet with each item in its own cell in column A.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.