Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding two columns

Status
Not open for further replies.

Fatih235

MIS
May 30, 2002
19
0
0
US
Hi ;

I have 2 columns like these.

a e
b f
c g
d h

and i would like to create a column like these

a,e
b,f
c,g
d,h

Suggestions please.
 
One way to do this is to use a formula to create a entry in a third column

=A1 & "," & B1

Copy the formula into the cells and copy them into the same range using paste special - selecting values.

or just leave the formula in place if you don't intend to delete the original columns.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top