How to split address in Excel_One setting to do it

How to easily split addresses in Excel? Addresses often contain multiple pieces of information, such as street, city, province, etc. Manually splitting this information is not only time-consuming, but also error-prone. In order to solve this problem, PHP editor Xinyi specially introduces a practical and efficient Excel setting method for everyone. With a simple operation, you can split your address at once. Come and take a look at this detailed tutorial to learn the specific steps, say goodbye to tedious manual splitting, and improve efficiency!

First we select all these addresses, then switch to the [Data] tab at the top and click the [Sort] function inside.

In the column wizard, we select [Fixed Width], which means adding spaces to align the fields in each column, and click Next.

Then we can see the ruler, click it and a dividing line will appear, which you can separate according to the classification you want.

Finally, click Next, and the information of this address will be separated. After checking that there is no problem, click Finish, and all the addresses will be quickly separated. .

The above is the detailed content of How to split address in Excel_One setting to do it. For more information, please follow other related articles on the PHP Chinese website!