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.

IBAN Numbers

• Intermediate
• 500
• 500 points

Working on banking operations.

IBAN Numbers

• Intermediate
• 500
• 500 points

Working on banking operations.

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

New Employee ID Badge

• Intermediate
• 1300
• 1.300 points

Using simple text function to create a digital staff identity card. You will be more advanced in using the text function...

Practice: IF Functions 3 - Other Functions and If

• Advanced
• 1000
• 1.000 points

Making more practice by using IF() function.

Practice: NameList

• Unknown
• 500
• 500 points

Practice your text functions skills.

Practice: NameList

• Unknown
• 500
• 500 points

Practice your text functions skills.

Practice: Product ID

• Beginner
• 500
• 500 points

Practice your text functions skills.

Practice: Product ID

• Beginner
• 500
• 500 points

Practice your text functions skills.

Practice: Separation and merge

• Unknown
• 500
• 500 points

Practice your text functions skills.

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

Create a summary of salesperson sales stats with the help of range lookup.

Salesperson Ratings

• Unknown
• 1700
• 1.700 points

Create a summary of salesperson sales stats with the help of range lookup.

Text Formulas – MID() & LEN()

• Beginner
• 250
• 250 points

Text Formulas – REPT() & LEN() for adding leading zeroes before incomplete Cheque Nos.

• Beginner
• 250
• 250 points

Text Formulas – Using LEN() & TRIM() together

• Beginner
• 250
• 250 points