Separate Address (Japan)

Separate Japanese address into prefecture, city, and street columns

How to Access This Feature

From Column Menu

Separate Address (Japan) Dialog

Optionally, you can specify new column names for following columns

  • prefecture

  • city

  • street

Click Run button then it will create new columns (prefecture, city, and street) as follows:

PreviousSeparate List Items into Rows (Unnest Longer)NextHoist

Last updated