New Text Functions

• Intermediate
• 600
• 600 points

Combine text strings using TEXTJOIN() and CONCAT().

Beverage Sales

• Advanced
• 1600
• 1.600 points

Drill down your sales data using an alternative lookup method.

Staff Data

• Advanced
• 1900
• 1.900 points

Getting some information with VLOOKUP on "Employee Data"

Badly Formatted Data

• Unknown
• 1200
• 1.200 points

Cleaning up data using various text functions which were given below. You will also correct some datas in the table.