您可以使用一个简单的功能– 粘贴为值 要完成此任务，请执行以下操作：
1。 选择要删除前导撇号的数据范围，然后按 按Ctrl + C 复制它们。
2。 然后单击要放入结果的一个单元格，然后单击鼠标右键，然后选择 123值 来自 粘贴选项，请参见屏幕截图：
在Excel中， 文字至栏 功能还可以帮助您解决此任务。
2。 然后点击 数据 > 文字至栏，而在 将文本转换为列向导，单击“ 完 直接单击按钮，请参见屏幕截图：
1。 按住 ALT + F11 键，然后打开 Microsoft Visual Basic应用程序 窗口。
2。 点击 插页 > 模块，然后将以下代码粘贴到 模块窗口.
Sub remove_Apostrophe() 'Updateby20150521 Dim rng As Range Dim WorkRng As Range On Error Resume Next xTitleId = "KutoolsforExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8) Set WorkRng = WorkRng.SpecialCells(xlCellTypeConstants, xlNumbers) For Each rng In WorkRng If Not rng.HasFormula Then rng.Formula = rng.Value End If Next End Sub
3。 然后按 F5 键以运行此代码，然后在弹出的提示框中选择要使用的数据范围，请参见屏幕截图：
4。 然后点击 OK，所有前导撇号已从所选单元格中删除。
Kutools for Excel“ 在文字和数字之间转换 实用程序可以帮助您一键将格式化为文本的数字转换为普通数字，并同时删除前导撇号。
|Kutools for Excel : 带有300多个便捷的Excel加载项，可以在30天内免费试用.|
安装后 Kutools for Excel，请执行以下操作：
2。 点击 库工具 > 内容 > 在文字和数字之间转换，请参见屏幕截图：
3。 在 在文字和数字之间转换 对话框，选择 文字转数字 在下面 转换类型，然后点击 Ok or 申请 按钮，将存储为文本的选定数字转换为实数，并且立即删除了开头的撇号。 如果您想将其转换回去，只需检查一下 文字编号 in 在文字和数字之间转换 对话框。查看屏幕截图：
You are guest
or post as a guest, but your post won't be published automatically.
To post as a guest, your comment is unpublished.· 5 months agodidn't work for me. I acutally needed to save a .txt, and find/replace with notepad++. mine were not showing up as a ', but a ?. not at all visible in Excel. thought I would share my experience in case it helps someone else.
To post as a guest, your comment is unpublished.· 10 months agoThe 2nd option worked for me with some modifications:1. I had to set the "Text qualifier" to the single quote2. I had to set the "Column data format" (on the next page) to Text
To post as a guest, your comment is unpublished.· 2 years agoThis is terrific! Thank you so much for providing a simple way to remove a leading apostrophe from a column. It was driving me crazy. Thanks again for all your help.
To post as a guest, your comment is unpublished.· 3 years agoPublic Sub REMOVE_APOSTROPHE()
Dim R_CELL As Range
Dim TEMP_VALUE As Variant
For Each R_CELL In Selection
TEMP_VALUE = R_CELL.Value
R_CELL.Value = TEMP_VALUE
To post as a guest, your comment is unpublished.· 3 years agoThanks for the tip - I used text to columns; great advice thankyou
To post as a guest, your comment is unpublished.· 3 years agoWhen the first two tricks do not work (this was in my case), I found another simple trick. This trick only works when all cells have the same number of characters behind an annoying ' that cannot be removed for whatever reason. 1-insert column next to cells with ' 2- enter into the new column formula "right" referring to cells with ' and insert no. characters after '. 3- Copy cells with formula-result and paste as values in the original column. 4- remove added column with formula.
To post as a guest, your comment is unpublished.· 4 years agoThanks, text to column work for me... :-)
To post as a guest, your comment is unpublished.· 5 years agoi LOVE THE vba CODE in theory but it didn't work :(
To post as a guest, your comment is unpublished.· 5 years agoDo you have any suggestions (preferably VBA) for removing apostrophes after numbers in excel? I have an excel file that takes data from an AutoCAD file and many of the values have one or two apostrophes (denoting feet or inches) but unfortunately this makes it unable to run equations on these cells. I know it is possible using "text to cells" but I was hoping using VBA would be possible.