How to return cell data as text in another cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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&" = "
 
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
 
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
----
Stony said:
Thanks Rob - thats exactly what I wanted!

Can you also tell me how to keep the formatting like the 1000 separator of
Click to expand...
the number when it is returned in the text cell?
 
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")
 
Thanks Max

It worked perfect - after I changed the comma(,) after the cell referencce to a semicolon (;)
 
You're welcome !
Glad to hear that
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
Stony said:
Thanks Max

It worked perfect - after I changed the comma(,) after the cell referencce
Click to expand...
to a semicolon (;)
 
Back
Top