There is a way to convert upper case to lower case in Excel (never
underestimate the powers of Excel!).
Here are the steps:
1) create a new column
2) put your cursor in the new column
3) Choose Insert --> Function
4) Choose Text --> Lower
5) Click on the text you want to change and hit OK
6) Drag the function along the whole column/worksheet, etc.
I encourage all Ebase admininstrators to get to know functions in Excel. I
spend all my time manipulating data in Excel before importing into
Ebase. You can separate First Name Last Name into two columns, merge two
columns into one, change those pesky dots into dashes for the phone
numbers, and a whole host of other database field issues.
--Amy
At 07:31 AM 3/22/01 -0500, Colin wrote:
>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
>---------------------------------------------------------------------
________________________________________________________
Amy Lesser, Communications Director ph: 202.547.8435 x15
Center for Environmental Citizenship fx: 202.547.8572
http://www.envirocitizen.org mailto:[EMAIL PROTECTED]
We've moved! Our new office is located at 200 G St. NE #300,
Washington, DC 20002. Please update your records.
Subscribe to EarthNet News, the largest student environmental
newsletter in the U.S., at http://www.envirocitizen.org/subscribe.html
________________________________________________________
------------------
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
---------------------------------------------------------------------
