Thread: Remove Apostrophe from end of number
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
octet octet is offline
external usenet poster
  
Posts: 8
Default 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

Reply With QuoteReply With Quote