![]() |
#8
|
||||
|
||||
![]()
the csv file you sent me was like:
Add1,,Add2,Add3,add4,add5,Postcode 01-Oct,,LOVAT PLACE,HILLINGTON,GLASGOW,,G52 4DS 11-Dec,,LOVAT PLACE,HILLINGTON,GLASGOW,,G52 4XE 1/7A,,MONTROSE AVENUE,HILLINGTON,GLASGOW,,G52 4LA I strongly suspect that the file you sent me was a file you'd already opened in Excel, deleted lots of rows and saved it under a new name. That file has been mangled by Excel. If you right click on the ORIGINAL csv file (you still have it don't you, before you opened it in Excel?) and choose Open with and choose NotePad, you should still see the likes of 06/04 or whatever in the addresses, remove a whole bunch of lower lines to avoid putting too much sensitive material into the public domain and to keep file size down, save it from Notepad under a new name (ending in .csv), then attach it here, zipped if necessary) so that I can experiment with it. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cenicero | Word | 2 | 10-20-2016 05:53 PM |
Saving as image file removes formatting | md61813 | PowerPoint | 0 | 03-01-2016 03:23 PM |
![]() |
cglenn | Word | 2 | 03-04-2014 08:13 AM |
Inserting 'Text from File' without loosing formatting | OverAchiever13 | Word | 2 | 05-28-2010 12:24 PM |
Formatting changes automatically after closing file. | Rashmirathi | Word | 1 | 09-08-2009 01:55 PM |