yogi_From A FirstName LastName Database Extract In NewNames Sheet FirstName LastName For A List FirstName_MI In OldName Sheet

                                          Google Spreadsheet   Post  #1180
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 08, 2013
user StudentSupport (https://productforums.google.com/forum/?hl=en#!category-topic/docs/spreadsheets/W0uqdxIvR9Q)

I began collecting student data based on a "first name, last initial". Now I am collecting it "first name, last name". To merge the spreadsheets I need to find a way to convert "first name, last initial" to the current format of "first name, last name". There is a master name database.  If there are multiple entries for it to either stay blank or somehow flag it for a manual conversion.

please click the link to find my example

https://docs.google.com/spreadsheet/ccc?key=0AvTqJBK5ZdjNdGpJS2tNZUY4bEY2cjRSWGNFZzBnUEE#gid=0

Old format:

Tom B.

New format:

Tom Brady

---------------------------------------------------------------------------------------------------------------------------------

Let us have a look at the following