HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
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".
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"silverflyer" wrote in message
...
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
|