View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
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