could you try
=MID(A1,2,LEN(A1) )

as the first chracter may not be a ' even though it appears to be.

"Sal" wrote:

This punctuation mark ' appears before every word in every row of column A.
Each row only has one word. I tried removing the punctuation mark ' using
the Replace function from the Edit menu. I put replace what: ( ' ) / replace
with: (blank), but it didnt work. I also tried other options from the help
menu but they didnt work out well either.

Is there a code that will remove ' punctuation mark from every cell in
column A that has a word written in it?