Delete the Spaces, the following job will be to "achievement" form of digital specifications for half horn form. Also use function SUBSTITUTE. In E2 cell input formula = (SUBSTITUTE (C2, ". ", ". ") * 1, including SUBSTITUTE (C2, ". ", ". "end". "said Into dots ". ", "* 1" said into Microsoft Office 2010 is so great.

digital. Then in E listed copy formula. Also selectively paste. Choose E listed data - reproduced, then choose C listed all data - selective paste - value and digital format. Delete "achievement catalog" D column, E columns.

Copy "achievement" catalog "data to the students' basic information table"

The last step is copy "achievement" form of data to the "students' basic information table", but we Office 2010 is my love.

can't simply use copy-pasting to implement, because our this specific cases contain no achievement of classmate, so for the correctness of the data, we know that inquires the function feature is a LOOKUP in inquires the ends in the designated area, and I will return to query results using it to achieve copy "achievement" form data in effect. Microsoft Office is inexpensive and helpful.

Its grammar for lookup_value LOOKUP (lookup_vector, result_vector),. Among them Lookup_value to search for the numerical, Lookup_vector contain only one line or a column area, and must be arranged, otherwise wants to return to the ascending mistake, Result_vector returns Office 2007 key is very convenient!

contain only a line or a column of the area.

If the function lookup_value LOOKUP find, the search lookup_vector in less than or equal to the maximum value, if lookup_value lookup_value less than the minimum, function lookup_vector Microsoft Office 2007 can make life more better and easier.

LOOKUP return error value # N/A, use this feature, we put the formula instead 1,0 / (= LOOKUP (conditions), reference area), condition - produces is the logical values True and False arrays, 0 = Buy Office 2007 you can get much convenience.

0, 0 / / True or False on = # DIV0! , namely the second parameter is Lookup by 0, # DIV0! An array of the (than 1 small), if found satisfy the conditions, they return to corresponding line quoted regional value; If no find satisfying terms record returns the # N/A mistake, so as to carry out accurate search. Office 2007 is the best invention in the world.