Remove Apostrophe from end of number
 

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

Remove Apostrophe from end of number
 

With your data in column A, in B1 enter:

=LEFT(A1,LEN(A1)-1) and copy down
--
Gary''s Student - gsnu200781


"octet" wrote:

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

Remove Apostrophe from end of number
 

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.

octet wrote:
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

Remove Apostrophe from end of number
 

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" wrote:

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

Remove Apostrophe from end of number
 

Thanks everyone

"Dave" wrote:

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" wrote:

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