HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

Sure, I can help you with that!

To use UPPER and CONCATENATE together in Excel, you can follow these steps:

1. First, decide on the text that you want to concatenate and convert to uppercase. For example, let's say you want to combine the first name and last name of a person and display it in all uppercase letters.
   
2. In a new cell, type the CONCATENATE function and open the parentheses. This function allows you to combine two or more strings of text into one.
   
3. Inside the parentheses, type the first text string that you want to combine. In our example, this would be the first name. Then, add an ampersand (&) to indicate that you want to add another text string.
   
4. After the ampersand, type the second text string that you want to combine. In our example, this would be the last name.
   
5. Close the parentheses and press Enter to see the combined text.
   
6. To convert the combined text to uppercase, simply add the UPPER function around the entire CONCATENATE function. This will convert all the text to uppercase letters.
   
7. Press Enter to see the final result.
   

Here's an example formula that combines the first name and last name of a person and displays it in all uppercase letters:

In this formula, A2 and B2 are the cells that contain the first name and last name, respectively. The space between the two text strings is added using quotation marks with a space in between.

Hi

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

--
Regards

Roger Govier


"silverflyer" wrote in message
...
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

Some more detail would help!

A1 = aaa
B1 = bbb

=UPPER(A1)&UPPER(B1)

Returns: AAABBB

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

Returns: AAA BBB

Biff

"silverflyer" wrote in message
...
HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

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


On Thu, 2 Nov 2006 10:50:02 -0800, silverflyer
wrote:

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