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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…