Formulas in a sentence
="We have been asked to contact you by our client, "&C6&", regarding your"
& " past due invoice for "&TEXT(C8,"$##0.00")&". Their records indicate"
& " that payment has not been received as of the date of this"
& " correspondence, and is therefore listed for collection. This"
& " balance may include finance charges."
I split the text/formula into pieces so that it looks nicer in the newsgroup.
And if you wanted to force lines where you want to, you can add &char(10)& to
the formula:
="this is one line"&char(10)&"this is the second."
But you'll have to change the format to allow wrap text.
Format|cells|alignment tab|check wrap text
in xl2003 menus
krissy wrote:
How would this formula go for this paragraph? Someone HELP PLEASE!!
We have been asked to contact you by our client =c6 , regarding your past
due invoice for =c8. Their records indicate that payment has not been
received as of the date of this correspondence, and is therefore listed for
collection. This balance may include finance charges.
--
Dave Peterson
|