is there a formula I can use to change the formats of addresses I pulled down in a data dump? I have a ton of addresses that show up like this in Excel:
"20 LONESOME DR "
I need them to look normal like this:
20 LONESOME DR
even with doing a find/replace for the parentheses it still has the issue with basically having two tabs instead of one space bar being used to separate the number and street name then one tab instead of spacebar for dr, st, pl, etc....
"20 LONESOME DR "
I need them to look normal like this:
20 LONESOME DR
even with doing a find/replace for the parentheses it still has the issue with basically having two tabs instead of one space bar being used to separate the number and street name then one tab instead of spacebar for dr, st, pl, etc....
