问题描述
作为标题，我在Excel 2016中找不到ASC / BIG5公式，是否有任何我错过的包或者应该添加一些加载项？
As title, I couldn't find ASC / BIG5 formula in Excel 2016, is there any pack I've missed or some add-in should be added?
我的要求是找到BIG5中的所有数据（数字，单词）并将它们替换为ASC，除了使用excel公式之外还有其他解决方案吗？谢谢。
My request is to find all data (number, words) in BIG5 and replace them into ASC, is there any other solution on that in addition to utilize excel formula? Thanks.
推荐答案
根据我的测试结果，Excel 2016 don'有BIG5配方。
According to my test result, Excel 2016 don't have BIG5 formula.
有ASC功能，我认为它适用于特定语言包。
在en-us语言包中，Excel不会提示该功能。在中文（简体）中，当我输入公式时，该功能将显示在下拉列表中。
There is ASC function and i think it works for specific language package.
In an en-us language package, Excel would not prompt for that function. In the Chinese (Simplified), the function would show in drop down list when i input formula.
>> 查找BIG5中的所有数据（数字，单词）并将其替换为ASC
Office不提供任何属性或方法来检查文本是否在BIG5或ASC中，因此我们需要遍历所有单元格并使用ASC函数进行转换。
这是一个简单示例。
Office doesnt provide any property or method to check if the text is in BIG5 or ASC, so we need to loop through all cells and use ASC function to convert.
Here is a simple example.
If ThisWorkbook.WebOptions.Encoding = msoEncodingTraditionalChineseBig5 Then
For Each sht In ThisWorkbook.Sheets
For Each cel In sht.UsedRange.Cells
If Len(cel.Value) > 0 Then
cel.Value = Application.WorksheetFunction.Asc(cel.Value)
End If
Next cel
Next sht
End If此外，我还建议你使用这样做。它适用于东亚区域设置，以便从ASC转换为BIG5或BIG5转换为ASC
Besides, I also suggest you use StrConv Function to do this. It applies to East Asia locales to convert from ASC to BIG5 or BIG5 to ASC
以下是StrConv的示例。
Here is the example for StrConv.
cel.Value = StrConv(cel.Value, vbWide)问候，
Celeste
这篇关于在Excel 2016中找不到ASC / BIG5公式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！