View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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