G
Guest
Hi
I have a series of numbers in each row with an apostrophe in the front. How
do i create a formula that can take out the apostrophe, so the zero in the
front of the number disappear leaving only numbers.
ex: '014564 --> 14564
'077454 --> 77454
'023457 --> 23457
'077875 --> 77875
I have a series of numbers in each row with an apostrophe in the front. How
do i create a formula that can take out the apostrophe, so the zero in the
front of the number disappear leaving only numbers.
ex: '014564 --> 14564
'077454 --> 77454
'023457 --> 23457
'077875 --> 77875