One last question/problem -- I followed your instructions below and was able to make the conversion to initial caps on the names in a new column, however, when I deleted the original column with the all caps names, the new column with the first letter only capital names converted to the following message in each field: #REF! and all my newly created names with only the first letter capitalized were gone.
How do I keep them?
Ileen
At 01:08 PM 3/22/01 -0500, you wrote:
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
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
---------------------------------------------------------------------
