Home  >  Article  >  Topics  >  How to delete the Chinese pinyin of the city name in column A data

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

藏色散人
藏色散人Original
2019-06-17 09:34:2215488browse

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

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

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

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

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

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

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

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

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

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

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

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

Complete

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

##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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn