Take a look at Importing GP Account Segment Descriptions

Recently I was reviewing some vendor address data within a spreadsheet that a client was preparing for import.  One of the columns contained telephone number s but they were not formatted consistently.  The client took on the job of editing the phone numbers.  When the updated file was ready for import I asked the client [...]