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?

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

=A1&" "&B1

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Pianoman" wrote in message
...
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?