<div>
Hi thanks,<br />
<br />
Would love a bit of VBA code or macro that would do the trick.
</div>


Hi thanks,

Would love a bit of VBA code or macro that would do the trick.

<div>
The following VBA code will remove <b>cubic m</b> anywhere on the current worksheet.<br />

<pre><code id="code-20-42773733-1">    Cells.Select
    Selection.Replace What:=&quot;cubic m&quot;, Replacement:=&quot;&quot;, LookAt:=xlPart
    Range(&quot;A1&quot;).Select</code></pre>
</div>


The following VBA code will remove cubic m anywhere on the current worksheet.


    Cells.Select
    Selection.Replace What:="cubic m", Replacement:="", LookAt:=xlPart
    Range("A1").Select

<div>
Thank's Sam,<br />
<br />
What would a Macro that would Call this code look like, to be used in any workbook?
</div>


Thank's Sam,

What would a Macro that would Call this code look like, to be used in any workbook?

Project Director

Jesper E Magnussen

<div>
You probably know this, but just in case, to put Sam's code in a macro the macro would look something like this.<br />
<br />

<pre><code id="code-20-42773746-1">Sub RemoveCubicM
Cells.Select
Selection.Replace What:=&quot;cubic m&quot;, Replacement:=&quot;&quot;, LookAt:=xlPart
Range(&quot;A1&quot;).Select
End Sub</code></pre>
</div>


You probably know this, but just in case, to put Sam's code in a macro the macro would look something like this.



Sub RemoveCubicM
Cells.Select
Selection.Replace What:="cubic m", Replacement:="", LookAt:=xlPart
Range("A1").Select
End Sub

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Have Excel 2016 workbook, With an Entity Volume (here in column &quot;C&quot; sometimes other columns), problem is that the software I got the data from have added string &quot;&nbsp;cubic m&quot; to the values and to sum up the data in the column I need to remove the added string With a click of a button. How do I get round that?
</div>
</div>


Hi,

Have Excel 2016 workbook, With an Entity Volume (here in column "C" sometimes other columns), problem is that the software I got the data from have added string " cubic m" to the values and to sum up the data in the column I need to remove the added string With a click of a button. How do I get round that?

Remove a right side 8 character string from a column of data

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.

Software

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.