Merge 2 or more coloumns into 1

dkennedy

New Member
Joined
Sep 24, 2006
Messages
13
I would like to know how to merge 2 or more coloumns into 1 without loosing any of the information from any of the cells. I would like to do this so as to facilitate the creation of a single coloumn with comma delimited information to transfer info into a database.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

How about concatenating:

I.E. =A1&", "&B1&", "&C1

Hope that helps,

Smitty
 

Watch MrExcel Video

Forum statistics

Threads
1,113,811
Messages
5,544,455
Members
410,612
Latest member
MrACED
Top