Concatenating Excel Cells

When you need to concatenate the content of two cells into a third cell, you can use

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

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.