Excel students register the names of students used the word in the space, and the location of a space of uncertainty, not to determine the number of spaces, which makes the name of this data is very neat, non-conforming. To be adjusted one by one, it can be a laborious and time-consuming. How can we resolve the "name" problem? After several attempts, I finally found the answer.

to delete the names of the spaces

to delete the names of the spaces, there are two methods: Method 1: Replace method. A selected list of the names of the host, the implementation of the "Edit ¡ú Replace" command in the "Find what" field enter a space, in the "Replace" column does not fill in any content, click "Replace All" command to determine the exit immediately after. Method Two: function formula. Excel in the "SUBSTITUDE ()" function, can help us easily in the name spaces are removed. In cell B2 enter the formula "= SUBSTITUTE (A2," ","")", determined to use the fill handle to copy the formula for it. Note: The formula in the middle of the first to have a space in quotation marks, quotation marks and the second is no space.

Name

the names of the students choice of words, some three Chinese characters, some two Chinese characters, print out very beautiful, giving students the names of the characters is a word about the alignment with the words there are two methods: < / p>

methods I: method format. We have chosen to delete spaces after the name of the cell, click the "Format ¡ú Cells" in the open "format cells" dialog box, select the level of alignment, "Alignment scattered" option to determine the withdrawal so that students can use the word about the names of alignment.

method II: function formula. The use of Excel's "IF", "LEN", "MID" combination of three types of function that students can be aligned around the names of characters. Specific examples as follows: In cell C3 enter the formula: "= IF (LEN (B2)> = 3, B2, (MID (B2, 1,1) & &" "& & MID (B2, 2 , 1 )))", determined to use the fill handle to copy the formula.