title: Select a part of Excel Cell (Not Complete Cell) and convert it to Uppercase by running a macro
body: <p>Select a part of Excel Cell (Not Complete Cell) and convert it to Uppercase by running a macro.</p>
  
  <p>I have a piece of code which will convert a selected cell or selected range of cells to Uppercase, but my requirement is, Selection will be a part (Sub String) of a cell and it should be converted to uppercase if I execute the macro.</p>
  
  <p>For example, I have a cell with value "Thanks for Helping"</p>
  
  <p>Now my code is:</p>
  
  <pre><code>Convert_To_Upper()
  Selection.value = UCase(Selection.Value)
  end Sub
  </code></pre>
  
  <p>If user selects the cell and runs the macro, cell will be changed to "THANKS FOR HELPING"</p>
  
  <p>Now my requirement is..</p>
  
  <p>If user selects only "Helping" from the cell and Runs the macro cell should be changed to "Thanks for HELPING"</p>
  
  <p>Is it possible achieve this?</p>