Formulas in a sentence

  • Thread starter Thread starter krissy
  • Start date Start date
K

krissy

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.
 
="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. "
 
="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
 
Try this...

="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."

You'll have to format the cell for word wrap and adjust the row height and
column width as needed.
 
Back
Top