Each line of the address is in different cells
I know this as I spent half a day splitting the addresses in the imported data. Well to be precise typing in comma delimiters then using split cell.

The problem is in using the wizards, which in my opinion leave a lot to be desired in terms of flexibility.

my current problem is word changing the date format format UK to US.