Practice File: Text_Functions_Practice.xlsx

Students should practice:

  1. LEFT
  2. RIGHT
  3. MID
  4. LEN
  5. TRIM
  6. UPPER
  7. LOWER
  8. PROPER
  9. CONCAT
  10. TEXTJOIN
  11. FIND
  12. SEARCH
  13. SUBSTITUTE
  14. REPLACE
  15. TEXT

Final Output: A professional Customer & Employee Data Cleaning Workbook.

PreviousNext