Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: 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:

Formula:
=UPPER(CONCATENATE(A2," ",B2)) 
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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,886
Default HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL

Hi

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

--
Regards

Roger Govier


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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,688
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 01:11 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"