Button pick a name for the constant then enter a formula in the Refers To field at the bottom of the resulting dialog. Paste Values with a Simple Keyboard Shortcut. Now you can see all formulas are.
Select the TEXT functions option.
Double-click the cell where you want to enter a line break. It is used when there is more than two outcomes for a particular given condition. Hi all I have a spreadsheet in which some cells have lost their formulas. You can then use the constant in a formula elsewhere in the workbook.