Display a string of text with multiple cell values

**paxile2k** · 07-30-2009, 01:37 PM

I am trying to create a formula to display a string of text that refers to multiple cells. for example, =If(A1=0,"insert text here" &B1 "insert more text here" &B2 "insert even more text here" &B3, "insert text here" &C1 "Insert text here"). Is this possible? It works fine for one cell value, like ="Total: " &A1

**ncmay** · 07-30-2009, 01:47 PM

Put the ampersand on the other side of the cell reference too.

Example:

="insert text here" &B1& "insert more text here"

Norman

**paxile2k** · 07-30-2009, 01:59 PM

Thankyou for your response,
That worked beautifully, is there way to round the value of a cell in that display to 2 decimal points also so it will clean up the display of the output?

**ChemistB** · 07-30-2009, 02:08 PM

Yes,

=TEXT(B1,"#.##")

Does that work for you?

**paxile2k** · 07-30-2009, 02:25 PM

Thankyou again for your response,
would the =Text(cell, "#.##") be used in the first formula for displaying text and cell values? or applied to the cell in question?
="insert text here" =TEXT(B1,"#.##)&B1& "insert more text here" ?