Can't get Excel to recognise a csv file

  splinternet 19:01 07 Nov 04
Locked

I've downloaded a csv file. How do I get Excel to recognise it as such and allocate each variable to a separate field? At the moment, it just clumps it all together into a single cell.

  VoG II 19:06 07 Nov 04

Have you tried Data/Import External Data ?

  splinternet 19:21 07 Nov 04

Thanks VoG. I wondered where this text import wizard was. I thought it was meant to pop up automatically when I try to open a csv file? I've noticed that each row in the csv file begins and ends with a double quotation mark, which the text wizard includes in the first and last field. Any way I can get rid if these?

  VoG II 19:26 07 Nov 04

Open the csv file in Notepad. Edit/Replace and replace all " with nothing.

  JaßîsFaß ˜ 19:38 08 Nov 04

Has that resolved the problem for you?

  splinternet 21:29 08 Nov 04

Yes. Thanks.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

Best Christmas Agency Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…