Listing down a column
Posted by Bill B on October 17, 2001 2:41 AM
How am I able to get a number/string and list each one of them down a column?
Posted by Dan on October 17, 2001 4:20 AM
I don't understand, can you give an example?
Almost sounds like a trick question!!
Posted by Bill B on October 17, 2001 4:42 AM
Re: I don't understand, can you give an example?
I just want to print out a list of file names that I have gathered from a procedure and show them listed in one of the columns in the spreadsheet!
Posted by Dan on October 17, 2001 5:39 AM
Re: I don't understand, can you give an example?
Ok, that's a little more information. I'm assuming that these file names are separated by a space, tab, column, or something. One way you could do it is: you can paste the string on to a single cell (maybe in a separate worksheet), then use Data -> Text to Columns to separate the names in to individual cells along a row, then Copy the range of cells and Paste Special -> Transpose on to the column that you want it to appear.
HTH
Posted by . on October 17, 2001 5:58 AM
http://support.microsoft.com/support/kb/articles/q149/6/89.asp
