How to return cell data as text in another cell

[Stony]

I have a data range (invoices), which I summarize in one cell. I woud like to be able to return the summarization as text in another cell

Not yet invoiced Contract amount: 11.974.957 - xxx =

where xxx is the summarization, which shall change each time the summarization changes

How do I do that?

 

[Rob]

Stony,

The following will include the value in cell A1. Is this what you wanted?

Rob

=+"Not yet invoiced Contract amount: 11.974.957 - "&A1&" = "

 

[Stony]

Thanks Rob - thats exactly what I wanted

Can you also tell me how to keep the formatting like the 1000 separator of the number when it is returned in the text cell

 

[Max]

Hi, I'm not Rob, but maybe you could try this amended one:

="Not yet invoiced Contract amount: 11,974,957 - "&TEXT(A1,"#,##0")&" = "

to get the thousand separator for A1

You may also wish to check out
Debra Dalgleish's nice coverage on the issue at:
http://www.contextures.com/xlCombine01.html

Look for the section on "Formatting Examples"
(near the bottom of the page)

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

Thanks Rob - thats exactly what I wanted!

Can you also tell me how to keep the formatting like the 1000 separator of

the number when it is returned in the text cell?

 

[Max]

Just a little add-on ..

One way to find out the formatting to write inside TEXT()
is to check what appears in the Custom format box (Number tab)
after you've applied the desired formatting to a cell

Let's say you've formatted A1
as a number to 2 d.p. with the thousands separator via:
Format > Cells > Number tab > Number | 2 d.p. | Checked 1000 separator box >
OK

Just click again on A1 and do a Format > Cells > Number tab > Custom

You'll see "#,##0.00" appear in the box under "Type:"
which gives the format to write inside TEXT(), viz.:

TEXT(A1,"#,##0.00")

 

[Stony]

Thanks Max

It worked perfect - after I changed the comma(,) after the cell referencce to a semicolon (

 

[Max]

You're welcome !
Glad to hear that
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----

Thanks Max

It worked perfect - after I changed the comma(,) after the cell referencce

to a semicolon (