ExcelBanter - Changing data format

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

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

- - Changing data format (https://www.excelbanter.com/excel-discussion-misc-queries/25687-changing-data-format.html)

frustratedwthis

Changing data format

I have a program that sends a report to excel, however, instead of putting
the information in coulmns, it places it all in one cell with spaces. Is the
only way to get all this information into columns, cut & paste or is there an
easier way?

Ron de Bruin

Try DataText to columns in the menu bar

--
Regards Ron de Bruin
http://www.rondebruin.nl

"frustratedwthis" wrote in message
...
I have a program that sends a report to excel, however, instead of putting
the information in coulmns, it places it all in one cell with spaces. Is the
only way to get all this information into columns, cut & paste or is there an
easier way?

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