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

P

Pianoman

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?
 
P

Peo Sjoblom

=A1&" "&B1

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

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top