Create an excel file consisting of ten students� names in the follow.pdf

Create an excel file consisting of ten students names in the following form: lastName, firstName,
middleName in a single column. (Note that a student may not have a middle name.)
Syafiqah, Siti, Nur
Tan, Shin,
Mimi, Lana, M
Write a program that converts each name to the following form, called as altered name:
firstName middleName lastName.
Siti, Nur, Syafiqah
Shin, , Tan
Mimi, M, Lana
Your program must read each students entire name in a variable and must consist of a function
that takes as input a string, consists of a students name, and returns the string consisting of the
altered name.
You should be able to sort the list from the source excel file and store the result in another excel
file. The resultant excel file should contain two sheets:
Syafiqah, Siti, Nur
Tan, Shin,
Mimi, Lana, M.

1. Create an excel file consisting of ten students names in the following form: lastName, firstName,
middleName in a single column. (Note that a student may not have a middle name.)

Syafiqah, Siti, Nur
Tan, Shin,
Mimi, Lana, M

Write a program that converts each name to the following form, called as altered name:
firstName middleName lastName.
Siti, Nur, Syafiqah
Shin, , Tan
Mimi, M, Lana

Your program must read each students entire name in a variable and must consist of a function
that takes as input a string, consists of a students name, and returns the string consisting of the
altered name.
You should be able to sort the list from the source excel file and store the result in another excel
file. The resultant excel file should contain two sheets:


Syafiqah, Siti, Nur

Tan, Shin,

Mimi, Lana, M