Removing apostrophe (') from the beginning

Hello,


I have an excel sheet where I have formulas with an apostrophe in the beginning.

Example:

'+34+54+56+22
'+34+222+224+556
'+92+922+12+42

I have one column with about 3000 of these.

Is there any way to remove the apostrophes AND calculate the formula at the same time? If I try to use the CLEAN() function, I have to copy and paste the formula as values. This causes the apostrophe to appear again.

Best regards,

Duffy