|  

» Joining text using formula in Microsoft Excel

Much like writing a formula to join text, as described, the Concatenate function allows you to merge values from multiple cells into a single cell.
In a formula, you create a space between words by pressing the Spacebar.
In the second box in sample figure, pressing the Spacebar will automatically add the quotation marks when you move to the next box.

Screenshot // Joining text using formula in Microsoft Excel
Joining text using formula in Microsoft ExcelJoining text using formula in Microsoft Excel
Rate This Tip
12 34 5
Rating: 2.79     Views: 96832
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments