I need to combine two text fields and add ()

N

Nigel Freeney

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
 
N

Nigel Freeney

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
 
Top