Contents
How to Remove Leading Apostrophe (‘) in Excel in Hindi
This video shows you how to remove apostrophe (‘) in excel using simple method. If you need to remove a single quote or apostrophe because somehow it may not be suitable or compatible with excel function or formulas.
You may ask, why should we need to remove Apostrophe before any number in Excel? So, please watch the full video to the end to learn how to remove unwanted leading apostrophe in excel.
I am discussing following method in this video in with proof.
Method 1 :
Just Copy and Paste as Values. This is the quickest method and works on Numeric entries only.
Method 2 :
Copy (CTRL+C) a blank cell – Select the range – Paste Special – Add. This also works on Numeric entries and removes apostrophes.
Method 3 :
Just select your range and Data tab – Text to Columns – Keep pressing OK till Finish. This also works on Numeric entries and removes apostrophes.
Method 4 :
Select you range – Home tab – Clear Format – This works on both Text and Numeric entries.
Method 5 :
VBA Method
A sample code is given below which you can customise as per your needs.
Sub RemoveApos()
Dim Rng As Range, Cell As Range
Worksheets(“Sheet1”).Activate
Set Rng = Cells.SpecialCells(xlConstants)
Cells(Rows.Count, Columns.Count).Copy
For Each Cell In Rng
If Cell.PrefixCharacter = “‘” Then
Cell.PasteSpecial Operation:=xlPasteSpecialOperationAdd
End If Next Cell
Application.CutCopyMode = False
End Sub
