Thread: [Solved] Condensing financial data
View Single Post
 
Old 03-25-2017, 02:49 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
To separate the data into individual columns, DATA TAB (up top Excel 2007) - TEXT TO COLUMNS.

When you get to the Delimiter type choose COMMA.

First, highlight all of Col A, then take the above steps.
Attached Files
File Type: zip tick_testing (2).zip (1.04 MB, 10 views)
Reply With Quote