How to put parenthesis in concatenated text (Numbers App)

Hi 8383,

Enclose everything that you want as text inside quotes "".

No need to use the CONCATENATE function. You can shorten the formula by using the concatenate operator &

="We had "&B2&" (but no "&C2&")"

Regards,

Ian.

Hi 8383,

Like this?

="""We had "&A3&" (but no "&B3&")"""

Regards,

Ian

Hi 8383,

In my last reply, the formula in cell D3 is:

="""We had "&A3&" (but no "&B3&")"""

That concatenates (joins together)

a quote character,

We had ,

the contents of Cell A3,

(but no ,

the contents of Cell B3,

another quote character

Giving the result

"We had Apples (but no Bananas)"

In Cell D3.

Please reply with a screen shot of a small part of your screen (command shift 4 and drag). Full screen shots (command shift 3) are often difficult to read. Please show the contents of the cells that you want to concatenate, and say where you want other characters such as ( ) or"

Wayne Contello has written a User Tip on how to post a screen shot.

https://discussions.apple.com/docs/DOC-6591

Regards,

Ian.

Are you saying:

you tried the example Ian posted and it works though you do not understand how it works? or

you tried the example and it doesn't work and you do not know why? or

you did not try the example because you do not understand?

It certainly makes sense to me but it is difficult to help you when we do not know what the problem is.

In all spreadsheet programs I am aware of there is a concatenate operator (the "&") that joins text.

if you type

=A1&" Hi"

then whatever is in cell A1 will be concatenated with (joined to) the test " Hi"

so... is A1 contains "Wayne", then result will be "Wayne Hi"

if A1 contains "Apple" then the result will be "Apple Hi"

if A1 contains "Apple" and B1 contains "Banana" you can join then using the formula:

=A1&B1

this will result in "AppleBanana"

if you want a space between then you could use:

= A1 & " " & B1

if you want parenthesis around the word in call B1 you could use:

= A1 & " ("& B1 & ")"