Expanding Abbreviations Within an Address Column

[sweeberry]

Hello experts,

I've got a canned report that I need to modify in Power Query so that it can be used to create an Excel mail merge list. The powers that be don't want any abbreviations in these addresses.

For example, Joe Smith's employee record comes out in the pre-canned export as 103 Anystreet Ln in MyTown, PA. I need to be able to convert this to 103 Anystreet Lane, MyTown PA, and was hoping to use Power Query to accomplish this.

I haven't had any luck finding a solution via Google. Hoping you all might have some insights. Thanks in advance

 

[jimrward]

Regardless of which way you try to solve this, excel, vba, pq it is likely to be an iterative process whilst you build up your list of short/long terms, once built it will be useful for the future providing it is not a one off exercise
Humans have a wonderful way of destroying data unintentionally of course