MicrostockGroup Sponsors


Author Topic: CSV display problem. Need help.  (Read 2217 times)

0 Members and 1 Guest are viewing this topic.

« on: January 16, 2017, 05:45 »
0
How can I import the CSV sales data from IS into Excel AND have a readable result?

Once I open the CSV file in Excel it's just a pile of long strings of numbers within one cell for each month. I can make out the monthly total, but not the individual sales types (Extended, Subscription etc.).

Is there a way to spread out the cells and align the numbers with the top line that contains the "titles"?

Thanks in advance.


« Reply #1 on: January 16, 2017, 10:18 »
+1
the way I used to fix this was a feature called something like 'text to field', where you pick a cell, and you can spread it out to many cells using a delimiter such as comma or space


To separate fixed-width text into multiple columns, follow these steps:
Highlight the range of cells that includes text to be separated.
Go to Data, Text to Columns.
Select Fixed Width from step 1 of the wizard and click Next.
Excel will guess at where the column breaks should go, as shown in Figure 3.9.

« Reply #2 on: January 16, 2017, 12:20 »
0
the way I used to fix this was a feature called something like 'text to field', where you pick a cell, and you can spread it out to many cells using a delimiter such as comma or space


To separate fixed-width text into multiple columns, follow these steps:
Highlight the range of cells that includes text to be separated.
Go to Data, Text to Columns.
Select Fixed Width from step 1 of the wizard and click Next.
Excel will guess at where the column breaks should go, as shown in Figure 3.9.
Thanks unnonimus, this gave me enough background to figure it out. For some reason I didn't have to select "Fixed Width" but the first option to make it work just fine.
Thanks very much!


 

Related Topics

  Subject / Started by Replies Last post
3 Replies
3260 Views
Last post November 28, 2006, 16:45
by a.k.a.-tom
14 Replies
3998 Views
Last post August 01, 2013, 23:47
by marthamarks
12 Replies
8667 Views
Last post February 27, 2016, 18:13
by Copidosoma
3 Replies
3911 Views
Last post March 22, 2015, 08:14
by Niakris
6 Replies
4449 Views
Last post November 22, 2017, 13:48
by obj owl

Sponsors

Mega Bundle of 5,900+ Professional Lightroom Presets

Microstock Poll Results

Sponsors