Joining Text and TEXT()
Join text with & or CONCAT. TEXTJOIN(separator, ignore_empty, range) joins a whole range with a separator between items. TEXT(value, format) turns a number into text in a chosen format, such as "0.00" (two decimals), "0%" (percent) or "#,##0" (thousands separator).
In this course each line of an example is one cell: the address, a colon, then what is in the cell. A line starting with = is a formula. Press Run to see the sheet with every formula worked out.
Exampleexcel
Quick check
Which function puts a comma between every item of a range?
Your turn: write the code
In C1 build the label 'Owusu, Ama' from first name A1 and surname B1.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.