Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download


AnalyserXL - Download


DownloaderXL - Download


Smart VBA - Download


TraderXL - Download

Concatenate Excel Cells/Join Cells in Excel

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS


Back to Tools for Excel Tables Start

Concatenate cells  
Do you wish to join text of many cells to a single cell?
Simply do this:
1. Select the cells of a row that you desire to concatenate
2. Click on the "Concatenate cells" button, in order to open the corresponding dialog box
Automatically the text boxes will be activated in the dialog box, in order to enter the text
that you want to add.
(if we don't enter any text, simply the content of the cells will be concatenated.
3. Press the Concatenate button. That is all.

This tool will make the concatenation in text or formula mode;
wherefore if the involved values change, the information will be updated.

See the following examples:


Back to Tools for Excel Tables Start

Tools for Excel Tables    Secure Payment Options

1 $89.95 USD
2 - 5 Licenses $79.95 USD
6 - 9 Licenses $72.50 USD
10+ Licenses $54.95 USD

Free Choice of Complete Excel Training Course OR OzGrid Add-ins Collection on ALL purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH!  Purchases MUST be made via this site.

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Contact Us