A text string, also known as a string or simply as text, is a group of characters that are used as data in a spreadsheet program. Text strings are most often comprised of words, but may also include letters, numbers, special characters, the dash symbol, or the number sign. By default, text strings are left-aligned in a cell while number data is aligned to the right.
Text and string processing functions in Excel:
1. ASC Function.
Syntax: =ASC(text).
2. CLEAN Function.
Syntax: =CLEAN(text).
3. CODE Function.
Syntax: =CODE(text).
4. CONCATENATE.
Syntax: =CONCATENATE(text1, text2…).
5. EXACT Function.
Syntax: =EXACT(text1, text2).
6. FIND Function.
Syntax: =FIND(find_text, within_text, start_num).
7. LEFT Function.
Syntax: =LEFT(text, num_chars).
8. LEN Function.
Syntax: =LEN(text).
9. LOWER Function.
Syntax: =LOWER(text).
10. MID Function.
Syntax: =MID(text, start_num, num_chars).
11. PROPER Function.
Syntax: =PROPER(text).
12. REPLACE Function.
Syntax: =REPLACE(old_text, start_num, num_chars, new_text).
13. REPT Function.
Syntax: =REPT(text, times).
14. RIGHT Function.
Syntax: =RIGHT(text, num_chars).
15. SEARCH Function.
Syntax: =SEARCH(find_text, within_text, start_num).
16. SUBSTITUTE Function.
Syntax: =SUBSTITUTE(text, old_text, new_text, instance_num).
17. T Function.
Syntax: =T(value).
18. TEXT Function.
Syntax: =TEXT(value, format_text).
19. TRIM Function.
Syntax: =TRIM(text).
20. UPPER Function.
Syntax: =UPPER(text).
21. VALUE Function.
Syntax: =VALUE(text).
22. CHAR Function.
Syntax: =CHAR(text).
23. BAHTTEXT Function.
Syntax:
24. CONCATENATE Function.
Syntax:
25. DOLLAR Function.
Syntax:
26. FIXED Function.
Syntax:
27. FINDB Function.
Syntax:
28. LEFTB Function.
Syntax:
29. LENB Function.
Syntax:
30. MIDB Function.
Syntax:
31. NUMBERVALUE Function.
Syntax:
32. PHONETIC Function.
Syntax:
33. REPLACEB Function.
Syntax:
34. RIGHTB Function.
Syntax:
35. SEARCHB Function.
Syntax:
Hopefully, the article summarizes the word processing functions and strings above will help you. Good luck!
