View Single Post
  #2   Report Post  
Old February 13th 06, 11:35 PM posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Default Copy column of cells to a single cell?

here is an idea from a getstockquotes program of mine

x = Sheets(1).Range("a" & Rows.Count).End(xlUp).Row
For Each c In Sheets(1).Range(Cells(5, 1), Cells(x, 1))
symbols = symbols & "+" & c

Don Guillett
SalesAid Software

"nastech" wrote in message
Hi, is there a formula or script for copying a column / selected range
that have one word in each cell, to a single cell.
Once in the cell, looking for separation between words with spaces, and to
sort as listed, or alphabetically. Thanks.