How to add one column to another column?

  • Thread starter Thread starter Rocky Lam
  • Start date Start date
R

Rocky Lam

I have a worksheet with product ID and Product Color Code and I like to
combine the two columns into one. For example


Column A Column B

123.445 AAA
124.892 ABC


Combine together like this

123.445.AAA
124.892.ABC


Thanks

Rocky
 
Rocky

In C1 type

=A1&"."&B1

and copy down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top