title: Google Sheets Formula for UPPER and PROPER text
body: <p>Sample file <a href="https://docs.google.com/spreadsheets/d/1K86FCnrvkZEk6lRHP6M_JSHIevWhMeqNku2TyGA6-hw/edit#gid=979671405" rel="nofollow noreferrer">here</a>.</p>
  
  <p>I need a formula that will convert space separated text such that the text is in PROPER case except where the word is in UPPER case which is left as is.</p>
  
  <p>So the following formula works - for one cell.</p>
  
  <pre><code>=ArrayFormula(JOIN(" ",IF(EXACT(SPLIT(A1," ",TRUE,TRUE),UPPER(SPLIT(A1," ",TRUE,TRUE))),UPPER(SPLIT(A1," ",TRUE,TRUE)),PROPER(SPLIT(A1," ",TRUE,TRUE)))))
  </code></pre>
  
  <p>But I want to convert a whole range at one go - ArrayFormula type. </p>
  
  <p>Possible? Using another method even.</p>
  
  <p>EDIT;</p>
  
  <p>'a BIG BAd   wOLF OF yonder' -> 'A BIG Bad Wolf OF Yonder'</p>