Need help with removing apostrophe while from data

Hi AmeenVanakar 

The solution  Irwan  provided you can give it a try but here is more optimized one
1. Simply go to powerquery by clicking on -> transform data tab and -> than under the add column use -> Column by example to have a new column based on your existing one but with removed aposhtrophe
For reference follow https://support.microsoft.com/en-us/office/add-a-column-from-an-example-power-query-cd82c570-8da7-4d70-91a1-3827b5995eab

2. Yes it is good to use cv=sv files as  It's widely used for data management due to its simplicity and compatibility with various software applications, making it ideal for data exchange

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Happy to help!