How to eliminate spaces in front of text in excel

thanks bro!

Thank you! Saved me a ton of time!

thank you! :)

I've copied and pasted addresses to excel and had to do this, but it won't work. (For example: Boston, MA 85220) Here I use "text to columns" function to separate whatever is in between the comas, but this leaves me with a space in front of the state abbreviation (Ex: _MA 85220). When I use the trim function, it won't delete the space that is in front of "MA". Any advice? Thank you.