Format

I am using Excel 2013. The spreadsheet has a lot of information listed in the same cell in one column.  I need to separate all items into multiple columns so I can filter and sort.  See example below.

 

A (column)

09/30/18 MR. ABC 15.25 16.30 5.23

A B C D E

 9/30/18 MR. ABC 15.25  16.30 5.23

Please advise.  

By: Helena

Leave a Reply

Your email address will not be published. Required fields are marked *