Verizon Contact List Imported To Gmail In Last Name First Form:

How would one reverse the order of the input from contacts to "last name first" order.. no where is there a help option on the site and from the postings so far there is not any fix listed.. as this is the only forum to address this (NO LIVE LIVE SUPPORT) please reply!

I Know the Answer!

I have the same question
Request More Information

Current Answers

Answer #1: Posted by jolted on November 22nd, 2009 11:11 PM

This answer was accepted by the poster of the original question.

jolted

Member since:
February 15th, 2010

Points: 13,930

1,100
points

You would think this would be easier...

Go to contacts
Select All
Export to a Google csv format file
BACKUP that file !!!!!! <- This is the most important step of the process!
Open the csv file you have just created using Excel (maybe there are other tools - that's what I used)
Create a new sheet (call it temp)
Copy the first column from sheet "Contacts" to sheet "temp" (Column Name: "Name")
In the "temp" sheet, select the only column (name) and go to Data->Text to Columns->Delimited->Next->space->next->finish
At this point the names and family names should appear in different columns
Check that there are no people w/ more than 2 names. If so, you will need to decide where to put the 3rd string so you stay w/ 2 columns only.
In Cell C1, write down "Name"
In Cell C2, write down the following: =CONCATENATE(B2," ", A2)
Copy this field to all cells in Column C
Now Column C should be filled with all names in the form of "Family Given".
Copy column C in sheet "temp" and paste it with Edit->Paste Special->Paste->Values to Column A in sheet "contacts".
Delete "temp" sheet
Save the file w/ a new name (newContacts)
Back to Gmail, delete all the contacts (not before you are sure you've saved that first file!!!!!)
Import the new new cvs file.