Remove Apostrophe from end of number

O

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
 
B

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.
 
D

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.
 
O

octet

Thanks everyone

Dave said:
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.
Click to expand...
 
Top