Excel Macro code to Remove the Apostrophe from a Number

Home
Macros Code
Formula Macro Code
Remove the Apostrophe from a Number

How to Remove the Apostrophe from a Number in excel sheet through VBA Macro Code

For using this VBA macro code in excel to Remove the Apostrophe from a Number you will have copy below Macro code in Excel Visual Basic Editor

Sub removeApostrophes()
Selection.Value = Selection.Value
End Sub

VBA Macro Code to Remove the Apostrophe from a Number in Excel

If you have numeric data where you have an apostrophe before each number, you run this code to remove it.

Excel Template Categories

Download Free PowerPoint Templates

Blue-Fluid-Business-Plan-powerpoint-template-or-google-slides-theme-720x405-1

Abstract ink Drop PPT template Feature image

3D-Printers-PowerPoint-Diagram-post-image

Arrows-bar-banner-PowerPoint-Diagram-Template-post-image

Brainstorming-PowerPoint-Diagram-Template-post-image

Business-man-banner-PowerPoint-Diagram-Template-post-image

What is a Macro Code?

In MS Excel, macro code is a programming code which is written in VBA (Visual Basic for Applications) language.

The idea is to use macro code for automating various activities which you perform manually in Excel, otherwise.

For example, you can use a code to print only a particular range of cells just with a single click instead of selecting the range -> File Tab -> Print -> Print Select -> OK Button.

How to use a Macro Code in Excel

Before you use excel VBA codes, make sure you have your developer tab on your Excel ribbon to access VBA editor. Once you activate developer tab you can follow below steps to paste a VBA code into VBA editor.