View Single Post
 
Old 02-04-2019, 11:22 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
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