USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
,
|
|
|
=
|
|
|
+
|
|
|
(
|
Detailed explanation-1: -An example of a delimiter is the comma character, which acts as a field delimiter in a sequence of comma-separated values.
Detailed explanation-2: -Any character may be used to separate the values, but the most common delimiters are the comma, tab, and colon. The vertical bar (also referred to as pipe) and space are also sometimes used.
Detailed explanation-3: -Common delimiters are commas (, ), semicolon (; ), quotes ( “, ‘ ), braces (), pipes (|), or slashes ( / ). When a program stores sequential or tabular data, it delimits each item of data with a predefined character.
Detailed explanation-4: -The two most common variants of delimited text formats are CSV (Comma Separated Values) and TSV (Tab Separated Values). In CSV files, columns are separated by a comma. Fields that contain commas or newline characters are quoted using double quote characters.
Detailed explanation-5: -A delimiter in c is a unique character or string that marks the start or stop of a particular statement, string, or function body set. Commas (, ), semicolons (; ), quotes (“ ”), braces (), pipes (|), and slashes (/) are common delimiters in c.