NewDeal Hot Tip 1000

[Hot Tips for...] NewCalc

Use NewCalc to Convert Case

You can use the UPPER() or LOWER() or PROPER() functions to change the case of up to 511 characters of text at a time.

Create a spreadsheet with the following formulas:

Save the spreadsheet as a template and use it as a tool when you want to convert the case of text from NewWrite or other applications. Just copy the text from the other application, paste into cell A1, and then copy the text in with the case you desire from cell A2, A3, or A4 and paste it back into your document in NewWrite or your other application.
Return to Index

Last Modified 27 Feb 1999