Share via

Excel- Chinese Character to Pinyin

Anonymous
2019-07-22T19:25:52+00:00

I am attempting to create an excel sheet which would copy a row with Chinese characters and create the pinyin in the next row. I know Word has this function where it can produce pinyin with the characters, however, I want to do this in excel to make an easy vocabulary list in which I can sort in multiple ways.

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2019-07-24T14:24:44+00:00

    Thank you, the best result I have is simply a copy and paste from a web source. Thanks for the effort

    5 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-07-25T02:03:59+00:00

    Hi Samantha,

    Thank you for sharing the workaround, this will benefit other community members.

    Best Regards,

    Tina

    0 comments
  2. Anonymous
    2019-07-23T06:43:58+00:00

    Hi Samantha,

    Thanks for your query in the community.

    Based on your description, I understand you want to produce pinyin with Chinese characters in Excel, show Chinese characters in a row and create the pinyin in the next row.

    I have tested from my side, unfortunately it is not available to achieve this requirement in Excel. Really sorry for the inconvenience.

    If you have concern about this, I recommend you send your valuable feedback to the related team by clicking File>Feedback, this would be the best way to let the developers know your requirement and help improving the product. Your understanding is appreciated.

    Best Regards,

    Tina

    0 comments