18 Text Functions in Excel You Need to Know

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:   / howtoexcelblog  
Twitter:   / howtoexcelblog  
LinkedIn:   / john-macdougall  

Thanks for all your support!