Yes!! That makes sense. I believe you have solved it. Thank you,
Rod Lindgren -----Original Message----- From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] On Behalf Of Alex Davidson Sent: Monday, July 10, 2006 1:27 PM To: [email protected] Subject: Re: [other] SOFTware; Capitalization in WORD and EXCEL 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. -- ---------------------------------------- WIN-HOME Archives: http://PEACH.EASE.LSOFT.COM/archives/WIN-HOME.html Contact the List Owner about anything: [EMAIL PROTECTED] Official Win-Home List Members Profiles Page http://www.besteffort.com/winhome/Profiles.html
