vert line

The Range->Convert sub-menu has the following commands:

Formulas to Values freezes the current values in the cell range that you selected. If you recalculate the worksheet, the frozen values will not change.

Strings to Numbers converts the string values in a given range to their number value. If a string cannot be converted, the cell is set to 0.

Numbers to Strings converts numeric entries in a range to their string value.

The Format->Text->Case sub-menu has the following commands:

To Upper Case converts string data in the cell or cell range that you selected to all capital letters.

To Lower Case converts string data in the selected cell or cell range to all lower case letters.

To Proper Case capitalizes the first letter of each word of string data in the selected cell or cell range

 

Also go to:

Index help

Contents help