Issue with deleting text from CSV file in Numbers
We are converting an Exel File into a CSV File by way of Numbers, in an effort to upload contacts into my Contacts database on my MacBook Air. The Contacts database does not like the CSV file and I am pretty sure it is because there is text in the phone number column. So a cell may read
"Office: 323.555.1212"
Before I change 600+ cells by manually taking out the word "cell" or "office" from these cells, I wonder if there is a way to format the column such that the text is ommitted. Thanks!
MacBook Air, OS X Mountain Lion (10.8.3)