Forum Discussion
NewbieJono
Post Partisan
Post PartisanSplit up addresses
i have a list of address in excel in this format Address line 1 Address line 2 Town Sa91pd Address line 1 Address line 2 Town Sa91pd Address line 1 Address line 2 Town postcode the...
NewbieJonoPost Partisan
Post Partisansorry, to make this more complaicated some address have 5 rows!
the postcode seem to be consitantly in captials if this is any help
v-kelly-msft
Community Support
Community SupportHi NewbieJono ，
Could you pls attach your expected output?It's a bit confused about your requirement.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!