J

#### Jose

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.