Learn the top 18 text functions in Microsoft Excel that you need to know.
1. CHAR function 0:17
2. TRIM function 1:29
3. EXACT function 2:39
4. CONCAT function 4:09
5. TEXTJOIN function 5:53
6. TEXT function 9:05
7. LOWER function 10:44
8. UPPER function 11:28
9. PROPER function 12:00
10. LEFT function 12:55
11. RIGHT function 14:02
12. MID function 15:02
13. LEN function 16:12
14. REPT function 16:54
15. FIND function 17:44
16. REPLACE function 19:45
17. SEARCH function 21:13
18. SUBSTITUTE function 22:59
Check out my full courses and ebooks here:
👉 https://www.howtoexcel.org/courses/
DOWNLOAD any example workbooks here:
📖 https://www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks.
📧 https://www.howtoexcel.org/newsletter/
CONNECT with me on social:
Facebook: https://www.facebook.com/howtoexcelblog
Twitter: https://twitter.com/howtoexcelblog
LinkedIn: https://www.linkedin.com/in/john-macdougall/
Thanks for all your support!
