>i have an excel file that has work phones listed as 865/637-6055 X24. Do
>I need to do anything to get them to properly import into the "work
>phone" line? I am concered about what to do with the extension and the
>area code.
ebase is bright enough to parse out the area code, but doesn't handle
the extension well. You should run through your list and pull the
extension numbers into a separate column. There are text functions in
excel that can extract the extension. This will work more or less
well depending on how consistently the extension is presented. If you
have a mix of 2-, 3-, and 4-digit extensions, and the designator is
sometimes x, sometimes ext, it will be tough. If there are few of
them, it's probably easiest to pull them off by hand.
Then import the area code/phone number into the phone number field,
and ebase will pull off the area code and put it into the area code
field as part of the import process
--
--
Dave Shaw H4 Consulting
tel: 206-954-7526 fax: 206-625-1338
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
