Removing apostrophe (') from the beginning

Solved/Closed
Report
-
 Duffy -
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

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
that apostrophe is saying that cell is a text

You can use text to column option that you see under "DATA"
Thanks! Works like a charm!