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.
