1. select the cells in the column and copy them
2. in an un-used area of the worksheet:
Edit PasteSpecial Transpose
3. copy the transposed data and paste in NotePad
--
Gary''s Student - gsnu200813


"Enni" wrote:

I have 1lack numbers in a excell sheet in column A, the same thing I would
like to copy in a notepad but I want numbers should come in horizontal i.e in
row. please help me out.