In order to facilitate recording some data, many partners have started using Excel software. So if you want to split the address in the form, how should you do it? The graphic steps are described below.

​​​​Take the following addresses as examples.

​ ​Select all these addresses, switch to the [Data] tab at the top, and click the [Sort] function inside.

In the column wizard, select [Fixed Width], which means aligning the fields in each column with spaces, and click Next.

Then you can see the ruler. Click it and a dividing line will appear. You can separate it 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 addresses will be quickly separated.

The above is the graphic and textual steps for splitting addresses in Excel that the editor has shared with you. Let’s learn together. I believe it can help some new users.