HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

B

Biff

Some more detail would help!

A1 = aaa
B1 = bbb

=UPPER(A1)&UPPER(B1)

Returns: AAABBB

=UPPER(A1)&" "&UPPER(B1)

Returns: AAA BBB

Biff
 
G

Gord Dibben

Please turn off the capslock.......hard on the ears.

With john in H3 and smith in I3

In J3 enter =CONCATENATE(UPPER(H3),I3) to return JOHNsmith

Slightly easier is to use the & operator to concatenate.

=UPPER(H3)&I3


Gord Dibben MS Excel MVP
 
R

RagDyer

If you have in Column A, from A1 to A5:
a
b
c
d
e

You could use:

=CONCATENATE(A1,A2,A3,A4,A5)
And have "abcde" returned.

You could also use:

=A1&A2&A3&A4&A5
And have the *identical* return, "abcde".

So, with less typing, simply wrap the ampersands with Upper():

=UPPER(A1&A2&A3&A4&A5)
And you'll get "ABCDE".

And if you would want spaces in between:

=UPPER(A1&" "&A2&" "&A3&" "&A4&" "&A5)
To get "A B C D E".
 
Top