=a2*4 & " Hi there " & a3*55
Don Guillett
SalesAid Software
[EMAIL PROTECTED]
----- Original Message -----
From: "Rod Lindgren" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, July 10, 2006 12:12 PM
Subject: Re: [other] SOFTware; Capitalization in WORD and EXCEL
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.
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.10/383 - Release Date: 7/7/2006
--
----------------------------------------
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.
