
Overview
An Excel macro that divides the address pasted in column A into prefectures, cities, towns and villages, and below.
Use scene
- Divide prefectures and cities when registering an address in BowNow, e-mail newsletter software, etc.
- When changing the business card management software, divide the address output in one line into prefectures and cities, wards, towns and villages.
- When analyzing a customer list, I want to extract prefectures from customer addresses ... etc.
How to use
- Start split_pref.xlsm
- Initially, you may need to have permission to edit (such as the content validation section).
- Paste the address you want to split into column A
- Click “Split” and you’re done
- If the state is not entered correctly, the line will be painted red. Please check the data

Precautions
- Please use at your own risk.