NewDeal Hot Tip 1000
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:
-
Cell A1 this is where you paste the source text
-
Cell A2 =UPPER(A1) copy the text from this cell if you want upper case
-
Cell A3 =LOWER(A1) copy the text from this cell if you want lower case
-
Cell A4 =PROPER(A1) copy the text from this cell if you want each word
in the string to begin with an upper case character and the rest of the
characters to be lower case
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