HomeApplicationOffice information

Text and string processing functions in Excel

In Excel, there are many groups of functions to help you process data quickly, one of which is a group of functions for processing text and strings.

The following article 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.

Text and string processing functions in Excel Picture 1

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.

Text and string processing functions in Excel Picture 2

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.

Text and string processing functions in Excel Picture 3

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.

Hopefully, the article summarizes the word processing functions and strings above will help you. Good luck!

3.5 ★ | 2 Vote

You should read it

May be interested

  • The MID function in Excel, how to use the MID function, and examplesThe MID function in Excel, how to use the MID function, and examples
    the mid function in excel, how to use the mid function, and examples. the mid function in excel is a function of the text function group, you use the mid function if you want to cut the string in the middle of the text string when processing the string. if you do not know or do not understand the mid function, then you
  • LEN () and LENB () functions in ExcelLEN () and LENB () functions in Excel
    the len () function returns the number of characters in the input text string. the lenb () function returns the number of bytes used to represent characters in the input text string. the lenb function only comes to 2 bytes per character when the default language is one of the languages ​​that supports dbcs.
  • The LOWER, UPPER and PROPER case-conversion functions in ExcelThe LOWER, UPPER and PROPER case-conversion functions in Excel
    in the text function group, the text conversion functions in the text are quite necessary and often used when manipulating, processing text and strings.
  • Separate text from strings in Excel, for example, and how to do itSeparate text from strings in Excel, for example, and how to do it
    separate text from strings in excel, for example, and how to do it. in excel, there are 3 basic functions that help you separate text from strings in excel: left, right, mid. if you are looking to separate words from a string, please refer to the article
  • String (String) in PHPString (String) in PHP
    string is a sequence of characters, you will find available string handling functions in php at php string (string) handler
  • Summary of trigonometric functions in ExcelSummary of trigonometric functions in Excel
    radians trigonometric functions, degrees, cos, ... in excel will help users to calculate quickly, compared to manual methods.
  • RIGHT () and RIGHTB () functions in ExcelRIGHT () and RIGHTB () functions in Excel
    the right () function returns the result as one or more final characters in a text string based on the number of characters you give. the right () function always comes with every 1 character whether it is single byte or double byte or whatever the default language is.
  • SEARCH () and SEARCHB () functions in ExcelSEARCH () and SEARCHB () functions in Excel
    the search () function and the searchb () function are two functions that help you process strings in excel. when you need to find the starting position of a substring in a text string without case or case, you use the search () or searchb () function.
  • Logical functions (logical) in ExcelLogical functions (logical) in Excel
    logical functions are used a lot during data processing in excel. the article summarizes the syntax and functions of functions in logical function groups in excel.
  • Common calculation functions in ExcelCommon calculation functions in Excel
    excel is a spreadsheet that supports functions that help you in the process of calculating and processing data, if you know the calculation functions, how to use them, your work will be processed more quickly.

Office information