Microsoft Office Professional 2016 ASC() and BIG5() function not found

Alias Leung 20 Reputation points
2023-03-01T06:32:49.1433333+00:00

My office version is Microsoft Office Professional Plus 2016. I found some website said that need to enable the developer mode. However, My excel can't found the ASC and Big5 function even enabled the developer mode.

Excel Result

ad27d39e-85cb-44b8-a5e4-f99b13c8bde0

Developer Mode991fca89-66e6-44c6-9083-69552d1becf9

Microsoft Document shows below function is able to Excel 2016.Can't found in Excel 2016.Can't found in Excel 2016.8a3b7fe3-4bf7-422a-86ae-95769e72b52f

Can't found in Excel 2016.

2fe826ea-c03e-40de-bbf6-2bd33e31dca0

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,439 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,638 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Hua-MSFT 27,526 Reputation points
    2023-03-01T08:59:44.62+00:00

    Hi @Alias Leung

    Based on my tests, Excel for Office Professional Plus 2016 does not support BIG5 function and supports ASC function for specific language, such as Chinese Simple , likes the following image.

    Capture1

    Under the case of using Chinese Simplified, if you need to change half-width (single-byte) characters to full-width (double-byte) characters, I suggest you try WideChar function.

    Capture2

    Here is a similar thread "Cannot find ASC / BIG5 formula in Excel 2016", you may also have a look.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful