The apostrophe creates a bit of a problem. But you can get around it.

Select the column and then COPY it.
Choose an empty column and use Paste Special and choose the Values option.
That will copy it all to the new column without the apostrophe. Then just
copy the new column back into the original one.

Quite often using the Paste Special will work without even changing columns,
but as I said, the apostrophe creates a bit of an issue, so the second column
is necessary in this case.

"James T" wrote:

I have a spreadsheet that has a column of functions that start with an
apostrope '

I need to remove the ' from the start of the function.

Tried using FIND/REPLACE but it does not like it.

Any ideas?