Can't get Excel to recognise a csv file

  splinternet 19:01 07 Nov 2004

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 2004

Have you tried Data/Import External Data ?

  splinternet 19:21 07 Nov 2004

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 2004

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

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

Has that resolved the problem for you?

  splinternet 21:29 08 Nov 2004

Yes. Thanks.

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

Elsewhere on IDG sites

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?