Text and String Processing Functions in Excel

This article provides a clear overview of Text and String Processing Functions in Excel, with the main facts, useful context, and practical details organized for easy reading.

this guide summarizes the text processing functions and strings in Excel.

1. ASC Function.

Syntax

ASC (text).

Function: The ASC function converts double-byte characters into single-byte characters.

2. BATHTEXT Function

Syntax

BATHTEXT (number).

Function: Translate numbers into words (Thai), then add the suffix "Bath" in the back.

3. the CHAR Function.

Syntax

CHAR (number).

Function: Convert a code in the ANSI code set (with a range of values from 1 to 255) into the corresponding character.

4. Ham CLEAN.

Syntax

CLEAN (text).

Function: Removes all unprintable characters from the string.

5. CODE Function

Syntax

CODE (text).

Function: Returns the code of the first character in the text.

6. CONCATENATE Function

Syntax

CONCATENATE (text1, text2.).

Function: Merge multiple strings into one string.

7. DOLLAR Function

Syntax

DOLLAR (number, decimals).

Function: Converts a number into a currency (US dollar), encloses the thousands separator and can do it as desired.

8. Ha EXACT.

Syntax

EXACT (text1, text2).

Function: Comparing two strings. If the same then return TRUE, if different then return FALSE. There are case-sensitive and case sensitive.

9. FIND Function.

Syntax

FIND (find_text, within_text, start_num).

Function: Find the start position of a substring (find_text) in a string (within_text), calculated by the first character.

10. FIXED Function.

Syntax

FIXED (number, decimals, no_commas).

Function: Converts a number into text format, with or without thousands separator, and round it up as you like.

11. the LEFT Function.

Syntax

LEFT (text, num_chars).

Function: Returns the first or more characters to the left of a string, in the specified number.

12. LEN Function.

Syntax

LEN (text).

Function: Count the number of characters in a string.

13. LOWER Function.

Syntax

LOWER (text).

Function: Converts all characters in a text string to lowercase.

14. MID Function.

Syntax

MID (text, start_num, num_chars).

Function: Returns one or more consecutive characters within a string, starting at a given position.

15. PROPER Function.

Syntax

PROPER (text).

Function: Change the first character in the string to uppercase, and change the rest of the characters to lowercase.

16. REPLACE Function.

Syntax

REPLACE (old_text, start_num, num_chars, new_text).

Function: Replaces part of a string with another, with the specified number of characters.

17. REPT Function.

Syntax

REPT (text, times).

Function: Repeat a sequence with the given number of times.

18. RIGHT Function.

Syntax

RIGHT (text, num_chars).

Function: Returns one or more characters from the right of a string, according to the specified number.

19. the SEARCH Function.

Syntax

SEARCH (find_text, within_text, start_num).

Function: Find the start position of a substring (find_text) in a string (within_text), calculated by the first character.

20. SUBSTITUTE Function.

Syntax

SUBSTITUTE (text, old_text, new_text, instance_num).

Function: Replaces one string with another.

21. Ham T.

Syntax

T (value).

Function: Returns a string if the reference value is string, otherwise returns an empty string.

22. TEXT Function.

Syntax

TEXT (value, format_text).

Function: Converts a number into text format according to the specified format.

23. the TRIM Function.

Syntax

TRIM (text)

Function: Delete all useless spaces in the text string, leaving only any spaces that are used as spaces between two words.

24. Ham UPPER.

Syntax

UPPER (text).

Function: Change all characters in the string to uppercase.

25. the VALUE Function.

Syntax

VALUE (text).

Function: Converts a string into a number.

FAQ

What is the main focus of Text and String Processing Functions in Excel?

The article explains the most important facts, context, and practical details related to Text and String Processing Functions in Excel.

Who may find this information useful?

It is useful for readers who want a clear overview, practical context, and a better understanding of the subject.

What should readers verify before taking action?

Check current product versions, official requirements, regional availability, and any details that may have changed since the original publication.