How to merge rows of data in 2 columns into 1 col.

I have 199 rolws of data in 2 cols and want to merge it into one col. for
printing lables. Excels instructions tell only how to merge 1 row, 2 cols
into 1 col. How do I do this?

=A1&" "&B1

copy down, then copy and paste special as values in place

--
Regards,

Peo Sjoblom

(No private emails please)


"Pianoman" <[email protected]> wrote in message
news:[email protected]...
>I have 199 rolws of data in 2 cols and want to merge it into one col. for
> printing lables. Excels instructions tell only how to merge 1 row, 2 cols
> into 1 col. How do I do this?