I need to combine two text fields and add ()

  • Thread starter Thread starter Nigel Freeney
  • Start date Start date
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
 
Enter this formula in C2:

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

Hope tis helps.

Pete
 
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
 
You must log in or register to reply here.

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

Similar Threads

Way to have a formula that combines the text of two different cell 8
merge contents of two cells together 10
Font codes for capitalization and small caps 7
Combining Text From Cells 3
Searching Uppercase characters 1
Why do Excel functions return the text and not run? 1
Create static text from cell reference 2
Combine Cells and Retain Color Fomatting 2

Back
Top