replacing tabs with spaces

[biglb79]

is there a way I can replace the use of a tab with just a single space bar? I dumped down a ton of data that separates names and numbers using a tab instead of just a single space. I tried the find replace function putting in five spaces with one space but that doesn't work

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1071308-formatting-addressses.html#post5145721

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).