I need to combine two text fields and add ()

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nigel Freeney - 23 Jan 2006 11:14 GMT

Hi,

Is it possible to combine the text contents of two cells and extra
characters sing a formula?
i.e. Result required A2(B2) in uppercase
The uppercase thing is not as necessary as the combined content and inserted
brackets.

Any help or suggestions of workarounds would be greatly appreciated.

Thanks,

Nigel

Reply to this Message

Pete_UK - 23 Jan 2006 11:28 GMT

Enter this formula in C2:

=UPPER(A2)&"("&UPPER(B2)&")"

Hope tis helps.

Pete

Reply to this Message

Nigel Freeney - 23 Jan 2006 11:33 GMT

Hi Pete,

Along the right lines I got the answer clue from an earlier post that
appeared after I had posted the question.

=UPPER(B2 & " (" & A2 & ")")

Thanks for the help - it would have got me there if I hadn't already worked
it out.

Nigel

> Enter this formula in C2:
>
[quoted text clipped - 3 lines]
>
> Pete

Reply to this Message