How to eliminate spaces in front of text in excel

Using the trim function to eliminate irregular spacing

[leooh]

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.

[paulmcmanus]

Yeah, but how do you then delete the original column with the spaces? When I delete, it comes up #ref! :( :(