Excel 2007 Concatenate Question


J

Jose

Lets say I have one row and three columns.

In the single row I have three columns like this:

A B C
11111 22222

I need a formula for column C that will concatenate column A and
column B together separated by a space and put parentheses around the
data in column B in the result so column C would look like this:

C
11111 (22222)

When done, the whole row should look like this:

A B C
11111 22222 11111 (22222)

I can get the concatenate to work and put the space between the two
and the opening parentheses but can't get the closing parenthesis to
work. It ends up like this:

A B C
11111 22222 11111 (22222

A working example, explanation would be appreciated.
 
Ad

Advertisements

B

Bernd P

Lets say I have one row and three columns.

In the single row I have three columns like this:

    A          B         C
11111    22222

I need a formula for column C that will concatenate column A and
column B together separated by a space and put parentheses around the
data in column B in the result so column C would look like this:

       C
11111 (22222)

When done, the whole row should look like this:

   A           B                C
11111    22222    11111 (22222)

I can get the concatenate to work and put the space between the two
and the opening parentheses but can't get the closing parenthesis to
work.  It ends up like this:

   A           B              C
11111    22222   11111 (22222

A working example, explanation would be appreciated.

Enter into C1:
=A1&" ("&B1&")"
If you insist to use the CONCATENATE function:
=CONCATENATE(A1," (",B1,")")

Regards,
Bernd
 
J

Jose

Enter into C1:
=A1&" ("&B1&")"
If you insist to use the CONCATENATE function:
=CONCATENATE(A1," (",B1,")")

Regards,
Bernd

Your first example works and the second complains that the formula I
typed contains an error... That looks like what I have been trying to
get to work,

I am new to Excel, so somehow had CONCATENATE on the brain and it
still doesn't work, but I will use the other method.

Thanks!
 
J

Jose

  Jose penned:






if you want to use CONCATENATE:

=CONCATENATE(A1," ","(",B1,")")

--
Steve

A bank is a place that will lend you money if you can prove that you
don't need it.
- Bob Hope

It still says my formula contains an error if I try that CONCATENATE.

The other method does what I want, but not getting CONCATENATE to work
remains annoying since I don't know how to do it.

Thanks for trying.
 
Ad

Advertisements

B

Bernd P

It still says my formula contains an error if I try that CONCATENATE.

The other method does what I want, but not getting CONCATENATE to work
remains annoying since I don't know how to do it.

Thanks for trying.- Hide quoted text -

- Show quoted text -

Try
=CONCATENATE(A1;" (";B1;")")

Regards,
Bernd
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top