View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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