Concatenating Excel Cells

When you need to concatenate the content of two cells into a third cell, you can use
=concatenate(a1,a2)

But here is an easier way. To try this method, type
1
into cell A1
and
2
into cell A2. Now, click in cell A5 and enter
=A1&A2

This will do the same thing as using "=concatentate()" function.

This tip comes from Sue Whitehouse of TipWorld.
home button   Just click on the button for the Tiproom's Home Page.
Date of last revision: 17 August 2001.