DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Replace cell references
|
|
|
Return ASCII values of characters
|
|
|
Concatenate and manipulate text
|
|
|
Show formula error value
|
Detailed explanation-1: -Text Formulas are fields that combine multiple text values into a single field, including values from other fields. Text formulas are very similar to equations and can be added as fields to objects within the “Schema” section in the Builder.
Detailed explanation-2: -The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It’s useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols.
Detailed explanation-3: -Use the ampersand & character instead of the CONCATENATE function. The ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1).