Remove ' in cell.

[dgavin]

in column C I have a list of numbers but some have a ' in front of them.

e.g 0777776666
'0777776667
'0777776668
0777776669

Is there a formula to remove the ' but without affecting the other cells ?

 

[MrKowz]

Try using Data>Text to Columns on that column.

 

[btadams]

Try this:

=IF(LEFT(A1,1)="'",RIGHT(A1,LEN(A1)-1),A1)