How to concatenate cells containing several words and spaces?

[slope]

It's numpty slope again trying to learn some trick spreadsheetery

I've discovered how to concatenate cells with only one word in each, but now I want to combine a string of characters, as in the example shown. So I want to add the numerical values in Column B (in parentheses preferably, or after a - hyphen) after the contents of the corresponding cells in Column C



If it's possible in Mac Numbers that would be bonzer, but I do have Excel 2008 for Mac also 

[Pingu]

Code: [Select]

=C2&"(H "&B2&")"

[Greenbank]

I'd be creating a new column between C and D that contains a concatenate formula such as:-

=CONCATENATE(B3; " "; C3)

and then hide columns B and C.

That way you can customise it, i.e.

=CONCATENATE(B3; " - "; C3)

=CONCATENATE("("; B3; ") "; C3)

...etc...

[psyclist]

Or in Numbers:

CONCATENATE(C2," (",B2,")")

[slope]

  You're all superstars

Thank yous