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

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

Peo Sjoblom

=A1&" "&B1

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

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Fetching data and deleting original data 3
A macro to copy & paste many rows (a range) to the next column .. 10
Excel spreadsheet to Word document 1
Macro for single to multiple cols. Help! 5
Counting unique values in multiple columns 4
tiny discrepancies in fixed-point numbers 3
Sub to freeze cols up to extent of data in col Q 6

Top