Download Practice Files Links :-

https://www.mediafire.com/file/20zl8lotew6e3mr/ALL+TEXT+FUNCTIONS.xlsx/file

20 Text Functions :-

1. CONCAT
2. CONCATINATE
3. TEXT
4. CONCAT + TEXT
5. CHAR
6. CLEAN
7. TRIM
8. TRIM + CLEAN
9. EXACT
10. FIND
11. REPLACE
12. LEFT
13. RIGHT
14. MID
15. LEN
16. REPT
17. SEARCH
18. SUBTITUTE
19. TEXT JOIN
20. TEXT AFTER
21. TEXT BEFORE
22. TEXT SPLIT