MicrostockGroup
Agency Based Discussion => iStockPhoto.com => Topic started by: click_click on January 16, 2017, 05:45
-
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.
-
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.
-
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!