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     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

Old format:
Tom B.

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