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.

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch