How-To Geek on MSN

This hidden Excel tool can quickly clean up your data automatically

Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
GitHub

A lightweight library to algorithmically convert numerical tone notation (e.g., hao3) to standard Pinyin diacritical marks (e.g., hǎo).

There is one key difference between v1 and v2: v2 does not support the format pinyin-number-r (e.g., hua1r) for erhua pronunciation. Instead, it supports the format pinyin-r-number, such as huar1.