Hi Michelle-
That was me. Here it is again.
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.
With the ALL CAPS column and the lower case column still there:
1) Create another new column.
2) Highlight the lower case column and hit "copy"
3) Highlight the new empty column, and go to Edit ---> Special Paste
4) Click on "Values"
5) Now you can (and should) delete the ALL CAPS column and the lower case
calculated column.
--Amy
At 07:59 PM 4/17/01 -0400, you wrote:
>>This was in a past digest, but I am now having the same problem and can't
>>figure
>>out how to use the Proper(text) function, which solution was offered. I have
>>already uploaded a list into ebase that was in all caps. I'd like to
>>convert it
>>to lower case in ebase if possible. I've read the FM manual and help but
>>can't
>>figure it out. It seems like that function is for when you create a new
>>field,
>>not for use in an existing field?
>>
>>Can anyone shed any light on how this function works? Much appreciated.
>>
>>Michelle L. Jones
>>Information Manager
>>PennFuture
>>212 Locust St., Ste. 410
>>Harrisburg, PA 17101
>>[EMAIL PROTECTED]
>>www.pennfuture.org
>
>
>Michelle,
>
>There was a more elegant solution using Excel than the one I can offer.
>
>I had the same problem: it would be better to open your names file in
>Microsoft Word before you import into ebase (I used v5.1 for Mac), select
>all, choose BBb button, select Title Case, and if your file isn't overly
>long (after a long wait without any signal anything is going on), you'll
>get lower case names, streets, etc. with initial capital letters.
>
>If you have already imported the all caps version of names into ebase, you
>can import the same, edited file again. When they are all identified as
>dupes, choose Set All to Update, select the items you want updated and
>import again.
>
>You will have to edit Mcqueen to McQueen, etc
>
>Have a backup handy before trying anything..
>
>Henry Bookout
>North Fork Environmental Council
>Mattituck, NY 11952
>
>------------------ 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
---------------------------------------------------------------------
