USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To combine strings of text, usually used when combing a last name and first name in 2 separate cells into one full name in one cell.
|
|
Backstage
|
|
|
Quick Parts
|
|
|
CONCATENATE
|
|
|
Sparklines
|
Explanation:
Detailed explanation-1: -Let’s say you want to create a single Full Name column by combining two other columns, First Name and Last Name. To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.
Detailed explanation-2: -Select the cell containing the last name (B2). In our example, your formula should now be: =CONCATENATE (A2, , B2). 10. Press the Return Key.
There is 1 question to complete.