Formulas in a sentence
 

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.

Formulas in a sentence
 

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

--
Gary''s Student - gsnu201001


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

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

Formulas in a sentence
 

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.

--
Biff
Microsoft Excel MVP


"krissy" wrote in message
...
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.

Formulas in a sentence
 

Thank you so much. How do I make the formula for c8 in dollars?

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu201001


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

Formulas in a sentence
 

Look at the responses that were provided to you yesterday.

Regards,
Fred

"krissy" wrote in message
...
Thank you so much. How do I make the formula for c8 in dollars?

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu201001


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