What is the apostophe doing in a cell

Hi,

Could anyone tell me why and what is the apostrophe doing in some of these cells. I would also would like to know why most cells in the same column do not have ths apostrophe.

See attached pictures.This is very problematic as it keeps me from exporting the data into SQL Server properly. Data that have an apostrophe will be transfered.