Taking out an Extra space before some entries in a column

[coastal]

I have an column called "email" with several records having an extra space

 

[L. Howard Kittle]

In a helper column =TRIM(A1) and fill down.

Copy > Edit > Paste Special > Values >OK to get rid of the formulas and copy
back to the original column..

HTH
Regards
Howard