Removing extra space before text in cell

[thirdeye85]

I was wondering if there was a way to remove the leading space next to the text. Suddenly, the columns started to add this extra one space to the formatting where previously there was no such space. I believe this was due to adding another column into the spreadsheet.

I had this occur in the past and fixed it without the trim function or macros, I am pretty sure it's an easy fix I just can't remember what I did.

 

[thirdeye85]

Answered my own question, I just had to select the entire column and then format everything in general again. I suppose those "rogue" cells didn't get the same formatting.