Some experts have compiled a special VBA function HztoPY to convert Chinese characters to Pinyin

Set A2 for the name, B2 formula = HztoPY (A2) can be used, and other conversion parameters can be selected according to need.

The document has detailed examples and instructions.

Pinyin with tones is very standard with TIMES New Roman.