Author Topic: How to concatenate cells containing several words and spaces?  (Read 327 times)

slope

  • Ride Fettle Ride
    • Current pedalable joys
How to concatenate cells containing several words and spaces?
« on: November 27, 2018, 01:04:15 pm »
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

  • Put away those fiery biscuits!
  • Mrs Pingu's domestique
    • the Igloo
Re: How to concatenate cells containing several words and spaces?
« Reply #1 on: November 27, 2018, 01:08:04 pm »
Code: [Select]
=C2&"(H "&B2&")"

Re: How to concatenate cells containing several words and spaces?
« Reply #2 on: November 27, 2018, 01:10:42 pm »
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...
"Yes please" said Squirrel "biscuits are our favourite things."

Re: How to concatenate cells containing several words and spaces?
« Reply #3 on: November 27, 2018, 01:11:50 pm »
Or in Numbers:

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

slope

  • Ride Fettle Ride
    • Current pedalable joys
Re: How to concatenate cells containing several words and spaces?
« Reply #4 on: November 27, 2018, 01:18:03 pm »
 :thumbsup: You're all superstars :)

Thank yous