Converting Chinese Characters to Pinyin/Jyutping on Google Sheets: now with more functionality
<p>You can now pass a range of cells or a whole column to the PINYIN() / JYUTPING() fuctions, for example:</p>
<ul>
<li><strong>PINYIN(A1:A20) </strong><em>this will convert cells A1 through A20</em></li>
<li><strong>PINYIN(A:A)</strong> <em>this will convert any chinese text present in column A. It will keep on converting as you add new rows in column A. Make sure you have no existing text in the target column.</em></li>
<li><strong>PINYIN(A3:A)</strong> <em>this will convert any chinese text present in column A, </em><strong><em>starting at row 3</em></strong><em>. It will keep on converting as you add new rows in column A. Make sure you have no existing text in the target column. (you may need to delete existing text)</em></li>
</ul>
<p><a href="https://lucw.medium.com/converting-chinese-characters-to-pinyin-jyutping-on-google-sheets-now-with-more-functionality-5047692950bf"><strong>Read More</strong></a></p>