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