I can't find any formatting tools in Excel that will change case on a batch
basis. Maybe someone else can.
If you're on a Mac, BBEdit 5.1 has a Text...Change Case function that will
capitalize and lowercase appropriately. Presumably there is an equivalent
program on PCs.
on 3/21/01 8:43 PM, Ileen Weber at [EMAIL PROTECTED] wrote:
> Someone suggested that I might solve the ALL CAPS problem by exporting the
> data to Excel, making the changes and then re importing.
>
> In fact I have an Excel spreadsheet of about 450 names and addresses that I
> want to import. These are new records. The whole database is in ALL CAPS. I
> can't figure out how to make the change to initial caps in Excel before I
> import. If this would be easier, can someone give me some instructions in how
> to do it in Excel?
>
>
> Ileen Weber, Membership Chair
> Pilchuck Audubon Society
> 1803 Hewitt Ave, Suite 108
> Everett, WA 98201
> 425-252-0926
> ------------------
> 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
> ---------------------------------------------------------------------
------------------
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
---------------------------------------------------------------------
