Special+Characters


 * Finding Special Character like arrows, checkboxes, and more.**

A way to get boxes and a lot of other symbols is to have your file open and go to the Edit -->Special Characters... menu. Checkboxes and other are in Miscellaneous. Special Character should work with most apps..

It looks like this icon on the upper right of your menu bar. I have Character Viewer open. Here is a sample of the Miscellaneous Symbols. easy!
 * You may also go to your System Preferences under the Apple menu.**
 * Choose Keyboard and**
 * ☑ Show Keyboard & Character Viewer in menu bar.**

There are two methods you can use to change existing cell values to upper, lower, or proper case. The first method is To change case with a formula, insert a blank column next to the column whose case you wish to change. In that column enter one of the following formulas, depending on what case you want as the result. Change the reference A1 to the first cell in your range. =UPPER(A1) =LOWER(A1)  =PROPER(A1)
 * Changing The Case Of Existing Text**

=concatenate(a1,b1) =concatenate(a1," ",b1) =concatenate(d1,e1)