Remove Apostrophe from end of number

[octet]

I have column with order 500 Records I need to remove the Apostrophe ‘ from
the end of each one can someone please tell me how.
0015762480000'

Thanks

 

[Gary''s Student]

With your data in column A, in B1 enter:

=LEFT(A1,LEN(A1)-1) and copy down

 

[Bob I]

Edit, Replace, Find what = ', leave Replace with blank. WARNING: you
will lose the leading "Zeros" so you will need to have formatted the
cells as text first.

 

[Dave]

Hi,
You could use Replace from the Edit menu.
Select the first cell in your column.
Edit menu > Replace
You should see the 'Replace' dialog box.
In the 'Find What' enter ' (apostrophe)
Leave the 'Replace With' line blank.
From the 'Search' dropdown, choose Columns
Click 'Replace All'

Regards - Dave.

 

[octet]

Thanks everyone

Hi,
You could use Replace from the Edit menu.
Select the first cell in your column.
Edit menu > Replace
You should see the 'Replace' dialog box.
In the 'Find What' enter ' (apostrophe)
Leave the 'Replace With' line blank.
From the 'Search' dropdown, choose Columns
Click 'Replace All'

Regards - Dave.