How to delete the Chinese pinyin of the city name in column A data

excel operation-delete the Chinese pinyin of the city name and add "city"

Method/step

Requirements In the worksheet, add A Delete the Chinese pinyin of the city name in the column data, and add the text "city" after the city name, such as Beijing

Select column B, right-click the mouse, and click "Insert" ”

Enter the function “=LENB(A2)” in the new column cell B2 to remove all characters

Continue to enter "-LEN(A2)" in the edit box to get the number of Chinese spelling characters

Then use the MID function to extract the Chinese characters, that is, enter "MID(" before LENB ,,”

Call up the function formula, starting from the first digit. The third parameter is the number of characters just found. The parameters are as shown in the figure

Add &"city" after the function, note that the double quotes are in English

Complete

##Update For more Excel-related technical articles, please visit the

Excel Basic Tutorial Column to learn!

The above is the detailed content of How to delete the Chinese pinyin of the city name in column A data. For more information, please follow other related articles on the PHP Chinese website!