If a window labeled Sort Warning appears, then you have not highlighted all of the data, in which case click the Cancel button on the Sort Warning window and try the previous step again. Choose to sort column C in ascending order. In the final drop-down box, choose Column A, and sort that in ascending order. Click OK . Your data has now been sorted.
C are blank, skip the following steps and proceed to the next set of steps .
The next set of instructions are going to be performed only on those rows where column B contains the first part of the last name and column C contains the last part of the last name. Find the first of these rows and highlight the F cell of that row. Press the Enter or Return key on your keyboard. Both parts of the last name should appear in the F cell of that row. Highlight that F cell again.