Can't get Excel to recognise a csv file

  splinternet 19:01 07 Nov 04

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.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

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

This animated short film tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…