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


Reply With QuoteReply With Quote