Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-04-2019, 11:22 PM
ArviLaanemets ArviLaanemets is offline Look up question Windows 8 Look up question Office 2016
Expert
 
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

This data row looks very strange for csv-file! So long I have encountered only comma and semicolon as csv-file delimiter.

Or is it text-file instead? And what is the delimiter - space or tab? When space, then you have a problem, as I see at least 3 parts of string which contain several words and contain additional spaces because this.

Anyway you need to split this string into separate columns in Excel. For this you have 2 options.

1. Simply open the file with Excel. When all entries remain in single column, use Text-To-Columns feature to split the column. You are asked for delimiter - set it tab or space depending on your data. NB! When delimiter is space, then e.g. "NEW YORK NY" is split into 3 different columns - this means that from different rows the sum is stored in different columns, so you have to edit the table manually after splitting;
2. You rename the file as *.txt, Open a new instance of Excel, and open this text file using Open Dialog. You are asked for column delimiter - choose right one. You also can determine data formats for every identified column. Proceed. All columns are split when the file is opened. NB!. When the delimiter was space, you again have to correct the result.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Look up question Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question rsrasc Word VBA 7 03-28-2014 12:28 PM
Question ... Need Help MdCadle PowerPoint 1 09-10-2012 09:04 AM
ppt question fat PowerPoint 0 10-06-2011 01:33 PM
Look up question One to many and many to one question Girlie4 Excel 3 08-09-2009 08:02 PM
Categories question & replying with attachment question glitzymama Outlook 0 03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 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