Replace Address Sufixes in Power Query

Save you some typing... use find and replace with your column name.
There are three examples of code below.

1. Change fully spelled out street suffixes to abbreviations.
2. Change street suffixes abbreviations to fully spelled out
 

Change fully spelled out to ABBVs.

Table.ReplaceValue(#"Col 1", each [YOURCOLUMN],

each if [YOURCOLUMN] ="STREET" then "ST"

else if [YOURCOLUMN] ="ROAD" then "RD"

else if [YOURCOLUMN] ="DRIVE" then "DR"

else if [YOURCOLUMN] ="COURT" then "CT"

else if [YOURCOLUMN] ="LANE" then "LN"

else if [YOURCOLUMN] ="BOULEVARD" then "BLVD"

else if [YOURCOLUMN] ="EXPRESSWAY" then "EXPY"

else if [YOURCOLUMN] ="EXTENSION" then "EXT"

else if [YOURCOLUMN] ="FREEWAY" then "FWY"

else if [YOURCOLUMN] ="HIGHWAY" then "HWY"

else if [YOURCOLUMN] ="ROUTE" then "RTE"

else if [YOURCOLUMN] ="TERRACE" then "TER"

else if [YOURCOLUMN] ="TRAILER" then "TRLR"

else if [YOURCOLUMN] ="AVENUE" then "AVE"

else if [YOURCOLUMN] ="CIRCLE" then "CIR"

else if [YOURCOLUMN]="PARKWAY" then "PKWY"

else if [YOURCOLUMN]="EXPRESSWAY" then "EXPY"

else if [YOURCOLUMN]="TRAIL" then "TRL"

else if [YOURCOLUMN] ="APARTMENT" then "APT"

else if [YOURCOLUMN]="BUILDING" then "BLDG"

else if [YOURCOLUMN]="FLOOR" then "FL"

else if [YOURCOLUMN]="SUITE" then "STE"

else if [YOURCOLUMN]="CIRCLE" then "CIR"

else [YOURCOLUMN],Replacer.ReplaceText, {"YOURCOLUMN"})

Change Abbreviations to FULLY spelled out 

Table.ReplaceValue(#"THE STEP PREVIOUS NAME", each [YOURCOLUMN],

each if [YOURCOLUMN] = "ST" then "STREET"

else if [YOURCOLUMN] = "RD" then "ROAD"

else if [YOURCOLUMN] = "DR" then "DRIVE"

else if [YOURCOLUMN] = "CT" then "COURT"

else if [YOURCOLUMN] = "LN" then "LANE"

else if [YOURCOLUMN] = "BLVD" then "BOULEVARD"

else if [YOURCOLUMN] = "EXPY" then "EXPRESSWAY"

else if [YOURCOLUMN] = "EXT" then "EXTENSION"

else if [YOURCOLUMN] = "FWY" then "FREEWAY"

else if [YOURCOLUMN] = "HWY" then "HIGHWAY"

else if [YOURCOLUMN] = "RTE" then "ROUTE"

else if [YOURCOLUMN] = "TER" then "TERRACE"

else if [YOURCOLUMN] = "TRLR" then "TRAILER"

else if [YOURCOLUMN] = "AVE" then "AVENUE"

else if [YOURCOLUMN] = "CIR" then "CIRCLE"

else if [YOURCOLUMN]= "PKWY" then "PARKWAY"

else if [YOURCOLUMN]= "EXPY" then "EXPRESSWAY"

else if [YOURCOLUMN]= "TRL" then "TRAIL"

else if [YOURCOLUMN] = "APT" then "APARTMENT"

else if [YOURCOLUMN]= "BLDG" then "BUILDING"

else if [YOURCOLUMN]= "FL" then "FLOOR" 

else if [YOURCOLUMN]= "STE" then "SUITE"

else if [YOURCOLUMN]= "CIR" then "CIRCLE"

else [YOURCOLUMN],Replacer.ReplaceText, {"YOURCOLUMN"})