(c) to remove the blank string

Patterns in the string, the blank is a valid character, but if a blank string of characters, it is easy to judge, or in contrast to data is an error in Excel, you can use the Trim function to remove the empty string.

Grammatical form: TRIM (text) which need to clear them for the Text text box.

It should be noted that, Trim function will not clear a single space between words, if even this part of space must be clear, then, it is recommended to use the replacement function. For example, from the string "My name is Mary" in the formulation of clear space for the function: TRIM ( "My name is Mary") = My name is Mary, see Figure 3

(d) comparison of string

Table in the data are often different than the string, you can use the EXACT function to compare two strings are the same. The function tests whether two strings are identical. If they are identical, then return TRUE; Otherwise, return FALSE. EXACT is case-sensitive function can be, but ignores the differences in format. EXACT function to test the use of input text files. Grammatical form: EXACT (text1, text2) Text1 be compared to the first string. Text2 be compared to the second string. For example: see Figure 4

EXACT ( "China", "china") = False

Figure 4