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.
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.