Thread: HOW DO I USE UPPER AND CONCATENATE TOGETHER IN EXCEL
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
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

Reply With QuoteReply With Quote