title: How to delete last character in a string with VBA?
body: <p>in this example below I want to remove the "B" using VBA. Thus, I download these values which spam from B5:F50 and all in the end have "B". My question is twofold. A) Is there a way to delete the "B" using VBA and replace these values in the same cells? B) Or have to be in new cells?</p>
  
  <p><code>77.65B 86.73B  92.97B  84.7B   89.4B</code></p>