HELP!! trying everything to remove first space in a column of data...nothing working

Hi there,
I imported a set of data from word that was comma delimited. I needed it to be a .csv to import it.
The data is all in Column A, about 2000 records. Some have the space, some do not.
I have tried trim, a specific formula, another one...and so on. i have attached an example of the file showing
a. the columns have some spaces, the others do not
b. my trim attempt to the right with to no avail

If i have to manually delete spaces in 2,000 records, i might shove a pen in my eye. Surely i'm missing something, please someone help!
Signed,
spending way too much time on this excel file in Tampa