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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top