How to remove space and symbols in front of words

I have a spreadsheet that I exported from my accounting software. For some reason there are 4 columns that all begin with an apostrophe and have various lengths of white space before the wording begins. What kind of formula can I use to get rid of the apostrophe and have the wording be left aligned within the cell with no space before or after it?

The file I am working on is attached. They are columns C, D, E and F.

Thanks!

Try in a new column:

=TRIM(SUBSTITUTE(D2,"'",""))

copied down for column D and then copy/paste special values over original column D. Then delete the formula column and repeat for columns E and F

1. to get rid of '
find replace ' with nothing
2
to get rid of leading space
select column
data/text to columns/
select fixed width
click next
double click on the breakline (if its there) to remove it
click finish