If your data is in Column A and starts in A1 then go to B1 and enter
your formula like:
=PROPER(A1)
and hit ENTER
that should give you a Proper Case version of A1 in B1.
From there, fill the formula down all the way to the bottom of your
data, Copy it, Paste the Values then delete Column A.
Make sense?
On 7/10/06, Rod Lindgren <[EMAIL PROTECTED]> wrote:
I still do not understand how to put both a formula and data into a cell
in Excel. I have found a rather cumbersome way to perform the operation.
I select the cells in the spreadsheet that I want to use, copy them to
the clipboard and paste them into a Word doc. Then I can select cells in
the Word doc and then use Format/Change Case. Then I save the Word doc
and use that as my data source.
There is a problem in that, sometimes, the copied table fro Excel will
be missing a cell or 2. This can be avoided if I make sure the cells are
large enough for the text within. Also, if all of the test in a group of
cells is not capitalized the same, using Chang Case can give unexpected
results.
It would be a great time saver if I could do the correction once in
Excel and just go with it.
Thanks,
Rod Lindgren
-----Original Message-----
From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] On Behalf
Of David Male
Sent: Friday, July 07, 2006 2:30 PM
To: [email protected]
Subject: Re: [other] SOFTware; Capitalization in WORD and EXCEL
> I have not found any way to do it in Word.
In Word, Format menu, Change Case should do it...
David Male
--
----------------------------------------
To Change your email Address for this list, send the following message:
CHANGE WIN-HOME your_old_address your_new_address
to: [EMAIL PROTECTED]
Note carefully that both old and new addresses are required.
