Wednesday, May 8, 2013

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   May 08, 2013
user StudentSupport (!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

Old format:
Tom B.

New format:
Tom Brady
Let us have a look at the following