MS Excel question…

How do I copy all cells w/i a column to a single cell. For example, I need to copy the values in cells A1-A10 into a single, comma delimited cell on another spreadsheet. Can this be done? Thanks in advance for any assistance.