HI all,
How can I remove blanks between words in a cell? How can I change below raw address into cleaned address? There is one blank between 123, one blank between Stre and et, 3 blanks between VIC and 21 and one blank between 21 and 30.
How can I remove blanks between words in a cell? How can I change below raw address into cleaned address? There is one blank between 123, one blank between Stre and et, 3 blanks between VIC and 21 and one blank between 21 and 30.
Raw Address | Cleaned address |
12 3 Maxwell Stre et VIC 21 30 | 123 Maxwell Street VIC 2130 |