Combine 2 columns without an expensive wizard?

A

Astello

Is there a way to combine 2 columns without a wizard? If I could put a
comma between them that would be great, but just slapping them together
is fine too.
 
M

Max

Assuming the source cols are cols A and B, data in row1 down
Put in C1: =A1&","&B1
Copy C1 down as far as required
 

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

Possible to Combine reports to's to a single box? 0
Excel does not accept text format! 0
List all tables, including document structure 0
VBA word change keys 0
I need to place a rule between columns 0
Insert Multiple Fields without Dialog closing between each... 0
Calculate the median value before a specified list 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top