/michael-pass.com

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.

1. ctrl + f to open the search and replace dialog box
2. enter ^[:space:]+ into the search box and leave the replace with box blank
3. done!