1. Number Formatting Shortcuts2. Cell Selection Shortcuts3. COUNT Function4. True & False5. IF Function6. SUM Function7. Arrow Keys8. Wildcard Characters9. SUMIF Function10. SUMIFS Function11. SUM Functions Skill Summary12. SUMIF Practice13. SUMIFS Practice14. COUNTIF Function15. COUNTIFS Function16. COUNT Practice17. COUNT Skill Summary18. AND, OR, XOR Functions19. IS Functions20. IFS Function21. SWITCH Function22. Larger Cell Selections23. Row and Column Selections24. Cell Selection Shortcuts 225. Larger Cell Selections 226. Cell Selection Skill Summary27. VLOOKUP Function28. VLOOKUP Function 229. VLOOKUP Practice30. HLOOKUP Function31. HLOOKUP Function 232. XLOOKUP Function33. XLOOKUP Function 234. MATCH Function35. INDEX Function36. INDEX MATCH Lookup37. INDEX MATCH Practice38. Index Match Skill Summary39. LEN, LEFT, and RIGHT Functions40. MID Function41. LEN, LEFT, RIGHT, MID Practice42. FIND Function43. SEARCH Function44. Intro to Shortcuts45. Text Formatting Shortcuts46. Cut, Copy, Paste47. Data Shortcuts48. AVERAGE Function49. MIN, MAX, LARGE, SMALL Functions50. MIN, MAX, LARGE, SMALL Practice51. FLOOR & CEILING Functions52. DATE Function53. TODAY Function54. DATEDIF Function55. DAYS Function56. DATE Functions Skill Summary57. CONCAT Function58. TEXTJOIN Function59. UPPER, LOWER, and PROPER Functions60. SUBSTITUTE FunctionIN PROGRESS61. Pivot Tables 162. Pivot Tables 263. Table Filters64. Tables Skill Summary65. ODD and EVEN Functions66. Worksheets67. Conditional Formatting68. MEDIAN Function69. MODE Function

SUBSTITUTE Function

0%

The SUBSTITUTE function replaces some text in a specified cell with a new string of text. To get a string of text that says "New Jersey", try typing
=SUBSTITUTE(A3, "York", "Jersey")





or press enter

ABCDEFG
1Minnesota
2California
3New York
4Florida
5Illinois
6
7
8


Today's High Scores 📈
1. Victory 7182
2. Dimas Bimantoro 3994
3. sun 3600
My Points Today: 0
You won't appear on the leaderboard until you log in or create an account

Today's High Streaks 🔥
1. iMaZz93 16 days
2. Victory 3 days
3. b 2 days
My Streak Today: 0
Complete a lesson today to start your streak!