title: How can I force Google Sheet to use .toUpperCase on a specific set of cells?
body: <p>I was searching for a way to force text in certain cells to UPPER CASE and came across a post at <a href="https://productforums.google.com/forum/#!topic/docs/QaRXTzt6lbw" rel="nofollow noreferrer">https://productforums.google.com/forum/#!topic/docs/QaRXTzt6lbw</a>.</p>
  
  <p>I am new to scripting and I found this to be very helpful. I was able to make it work, but only in 1 column.</p>
  
  <p>My dilemma is I am trying to make multiple columns force UPPER CASE letters.</p>
  
  <p>I want it to start on row 4 of all specified columns. I am looking for the script to run on columns 2, 5, 10-14 &amp; 18-29. More specifically, I am looking to make this work on a set range (B4:B53, E4:E53, J4:N53, R4:AC53)</p>
  
  <p>If anyone can offer any insight on how I can make this happen, it would be very greatly appreciated.</p>
  
  <p>I should mention that I have tried several ways to modify the formula in the above mentioned script, but have been unsuccessful in making it work. The most I can make it do is work for column 2 and 5.</p>
  
  <p>Thanks.</p>