Forum Discussion

Copper Contributor

Apr 20, 2018

Converting .csv from AutoChartist.com to number format

I am importing data from AutoChartist.com using From Text in the DATA tab. The data comes in as a .csv file. The values in the cells have quotation marks around the numbers (see file) so that Excel t...

2018-04-20_NQ__hourly_movement_in_en_GB.csv1 KB

BI & Data Analytics

Need Help

Haytham Amairah

Silver Contributor

Apr 20, 2018

Hi John,

The most efficient and easy way to do that is to use the Find and Replace tool as follows:

Select all the numbers
Press Ctrl+H to open the Find and Replace tool
In Find what box, type a single double quote "
Leave the Replace with box blank as it is, and then hit Replace All

Regards