i was working on a spreadsheet for a customer and it had over 6000 cells in it. every single cell had a leading space. after much searching on google, i finally found the correct answer, and here it is.
ctrl + fto open the search and replace dialog box
^[:space:]+into the search box and leave the replace with box blank