Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago

Split 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...
Need Help
NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago

sorry, 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's avatar
v-kelly-msft
Community Support
5 years ago

Hi 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!