I have an Excel file I need to clean up some data
This is what I have and need to know how to remove unnecessary black spaces.
Suite 22 - 222 Anywhere Street
I don not want to remove the space in Suite 22 and so on. The field size are all different and spaces. I have attached an excel sample.
Can someone help me with this?