Currently Being ModeratedMay 13, 2013 2:43 PM (in response to gergenson)
The most likely reason that Contacts doesn't like your CSV files is that they don't have the right fields.
The best, and only practical way, to format a table for eventual import to Contacts is to first create a Numbers table template with a record from Contacts. Drag a Contact from your Contacts app to a blank part of a Numbers Sheet. This will create a table with the proper columns for import to Contacts after you fill it with your external data. There will be only a few columns showing, so you must "Unhide All Columns". Then you will see, by looking at the labels in the Header Row, where you data must be located.
Currently Being ModeratedMay 14, 2013 2:52 AM (in response to gergenson)
Find and Replace in Numbers.
Edit > Find > Show Search (command f) will bring up a search box:
Click on Find and Replace.
In the Find box, type Office: followed by two spaces (there are two spaces in your example).
Leave the Replace box empty.
Click on Replace All.
Repeat this for Cell.
That editing process will replace the Find text with nothing, and will leave the rest of the cell contents unchanged.