PRODUCT  :  Quattro Pro                            NUMBER  :  533
VERSION  :  All
     OS  :  DOS
   DATE  :  March 16, 1991			     PAGE  :  1/4

  TITLE  :  Text Formulas




Text formulas are formulas that result in a textual entry.  Text
formulas include those created with string functions (see the
User's Guide) or an @function that results in a string.

There are (generally) three parameters to a concatenated string:

1.  +	       The plus symbol (+) specifies the trailing text as
	       a formula.  Always begin a text formula with a '+'
	       sign.

2.  constant   The constant is the part of the formula which will
	       not change.  Constants should be placed within
	       quotes.

3.  variable   The variable is the part of the formula which is
	       being concatenated to the constant.  It is
	       preceded by an ampersand (&), and should be
	       followed by another ampersand if there is more
	       information to add (concatenate) to the end of the
	       string.	Variables must be valid text strings.
	       Use the @STRING function if the variable is not a
	       text string -- this converts the variable to a
	       string format.


EXAMPLES


Example 1

     +"Book"&" Review"

This example concatenates the text string "Book" with the text
string " Review".  The result is "Book Review".

If you break this example into its appropriate parts, you will
find a '+' sign (denoting a formula), and two constants ("Book"
and " Review").  In this case, there is no variable.  This is a
redundant type of example, but it does show the manipulation of
strings in formulas.
















PRODUCT  :  Quattro Pro                            NUMBER  :  533
VERSION  :  All
     OS  :  DOS
   DATE  :  March 16, 1991			     PAGE  :  2/4

  TITLE  :  Text Formulas




Example 2

     +C4&" Review"

This example takes the contents of cell C4, adds a space and the
text 'Review' to C4's contents.  If C4 contains the label 'Book',
the result of this formula will be 'Book Review'.

Again, note the '+' sign beginning the formula.  However, C4
becomes the variable.  Since the contents of C4 can change at any
time, it is referenced as a variable.  The constant in this case
is " Review".  In this example, it is assumed that C4 contains a
label.	The next example shows the formula needed if C4 contains
a value.

Example 3

     +@STRING(C4,0)&" Review"

This example is similar to the previous one except the @STRING
function is used to translate a value in C4 to a string so it can
be used in the formula.  If C4 contains the value '4', the result
is "4 Review".

Example 4

+"{GETLABEL ""Enter Name: "","&@CELLPOINTER("address")&"}"

This example prompts the user for a name and places the response
in the current cell since {GETLABEL} requires a valid block in
which to store the response.  Since the address in this example
is variable, the address is added when the command is executed.

			   * * * * * *

+  "{GETLABEL ""Enter Name: "","  &@CELLPOINTER("address")  &"}"
³  ÀÄÄÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÄÄÄÙ  ÀÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÙ  ÀÄÂÙ
P	      First			  Variable	   Second
L	     Constant					 Constant
U
S

			   * * * * * *













PRODUCT  :  Quattro Pro                            NUMBER  :  533
VERSION  :  All
     OS  :  DOS
   DATE  :  March 16, 1991			     PAGE  :  3/4

  TITLE  :  Text Formulas




+	       Indicates the following text as a formula.

"{GETLABEL ""Enter Name: "","
	       The first constant.  Notice that the constant is
	       enclosed in quotes while the prompt for {GETLABEL}
	       is enclosed in a pair of quotes.  This is
	       necessary so one set of quotes will appear after
	       the string formula has been calculated.

&@CELLPOINTER("address")
	       This is the variable.  Notice the result of this
	       function will be a text string (the address of the
	       current cell).  Notice the ampersand (&), which
	       indicates the following string should be appended
	       (concatenated) to the previous string (the first
	       constant).

&"}"	       The second constant.  Notice that the constant is
	       enclosed in quotes.  Since the string is to also
	       be appended within the formula, it too is preceded
	       by an ampersand.


Example 5

     +"{LET "&@CELLPOINTER("address")&",A25}"

This example takes the contents of cell A25 and places it in the
cell referenced by the cell selector.  This initializes the
current cell to the contents of cell A25.


			   * * * * * *

     +	  "{LET "    &@CELLPOINTER("address")	&",A25}"
     ³	  ÀÄÄÂÄÄÙ    ÀÄÄÄÄÄÄÄÄÄÄÂÄÄÄÄÄÄÄÄÄÄÄÙ	ÀÄÄÄÂÄÄÙ
     P	   First	     Variable	      Second
     L	   Constant		    Constant
     U
     S

			   * * * * * *














PRODUCT  :  Quattro Pro                            NUMBER  :  533
VERSION  :  All
     OS  :  DOS
   DATE  :  March 16, 1991			     PAGE  :  4/4

  TITLE  :  Text Formulas




+		    Indicates the following text is a formula.

"{LET "             The first constant.  Notice that the constant
		    is enclosed in quotes.

&@CELLPOINTER("address")
		    The variable.  Notice that the result of this
		    function will be a text string (the address
		    of the current cell).  Also, notice the
		    ampersand (&), which indicates the following
		    text string should be concatenated to the
		    previous string (the first constant).

&",A25}"	    The second constant.  The ampersand indicates
		    that this constant should be appended to the
		    previous string.  Notice the quotes around
		    the constant.

When a text formula is used within a macro, precede the
concatenate command with a {CALC} command.  Spreadsheet
recalculation is suspended while a macro executes.  Therefore, to
ensure that all text formulas are current before executing them,
the {CALC} command should be used to update the formulas.

Concatenating text strings takes practice and patience.  Try
manipulating other sorts of text strings until you are
comfortable with the operation.