回复：dunno how to solve your " ' " problem but

but the dates are all different..
the ' was put in to keep the text from changing into numbers.

but now i want ' to disappear:'(
i try to find and replace 'January with January, but it couldn't find anything ~~>.
do i have to go through each individual cell and delete that manually????

there are hundreds of them:'(