How to combine two text in Excel | Video #7
This video will help you understand how to combine two or more words by using Concatenate and &
The CONCATENATE function in excel is designed to join different words of text together or combine values from several cells into one cell
The syntax of excel CONCATENATE is as follows:
CONCATENATE(text1, [text2], …)
The Other way to combine text from two or more cells into one cell
Select the cell where you want the result of the combined data then type equal to (=) and then select the first cell you want to combine and then type & and use quotation marks with a space enclosed (" ") and type & again and then select the next cell you want to combine and press enter. If you want to join more words you can repeat this step multiple times
An example will be like =A1&" "&B1.
Hope you have liked the video. Thank you for watching
Subscribe to my channel for more video updates:
/ @excelwithkumar
Excel Beginner to Intermediate within 60 minutes playlist:
• Getting started with Excel - The Beginners...
#MicrosoftExcel
#ExcelwithKumar