Concatenate Values (Office 2000-2003)

Topic

New Reply

Hi Everyone,
I am trying to concatenate the following: a cell with a formula that results in a total of 104.58; Another cell with a formula that results in 65.20. I would like to use concatenate to write these numbers as a ratio, rounding the numbers – as in 105:65. I can’t seem to come up with the correct formula and I know it probably is placement of the parentheses: =concatenate(value(round(a1)+”:”+value(b1)). Help please?

TIA

Reply | Quote

Replies

Try:


=ROUND(A1,0)&":"&ROUND(B1,0)


Reply | Quote

Legare, that formula results in #VALUE!

Thanks.

Reply | Quote

That says that one of the two values is a text string, not a number and therefore can not be rounded.

Reply | Quote

Here is a strip-down version of the spreadsheet. See the highlighted cells starting in B44.

Reply | Quote

Excel doesn’t like to concatenate number values. Try this:

=TEXT(B44,"0")&":"&TEXT(B48,"0")

Reply | Quote

That did it – perfectly!!

Thanks Hans!

Reply | Quote