ExcelBanter - rec'd imported "date,value" in one column how do I separate?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - rec'd imported "date,value" in one column how do I separate? (https://www.excelbanter.com/excel-discussion-misc-queries/161999-recd-imported-date-value-one-column-how-do-i-separate.html)

FL_Geezer

rec'd imported "date,value" in one column how do I separate?

want to put this into 2 columns in Excel spreadsheet

JE McGimpsey

rec'd imported "date,value" in one column how do I separate?

One way:

Choose Data/Text to Columns...

In article ,
FL_Geezer wrote:

want to put this into 2 columns in Excel spreadsheet

All times are GMT +1. The time now is 10:10 PM.