Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 07-01-2019, 05:11 AM
p45cal's Avatar
p45cal p45cal is offline Formatting of CSV file Windows 10 Formatting of CSV file Office 2016
Expert
 
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting of CSV file Formatting a word file cenicero Word 2 10-20-2016 05:53 PM
Saving as image file removes formatting md61813 PowerPoint 0 03-01-2016 03:23 PM
Formatting of CSV file Appendix file looses some formatting when inserted 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft