Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
HOW DO I FORMAT DATA FROM YY/MM/DD TO MM/DD/YY? | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
How can I keep a cells format, general, from changing after enter. | Excel Discussion (Misc queries) | |||
Format Data Series Markers | Charts and Charting in Excel |