I've run a simulation and specified the waveforms to print their data in the numeric output file. If I open the numeric output file and then copy and paste the tabular data into Excel, all of the data copied gets pasted into a single cell. How do I send this data over to Excel so that it will place each piece of data in its own cell?
When numeric output is enabled for a waveform and the simulation is run, a column of data for that waveform will be placed in the Numeric Output file which can be accessed under the specific analysis menu (Transient, AC, or DC). This output is just a text file that will have one of the extensions: .TNO, .ANO, or .DNO depending on the type of analysis that was run. In Excel, you can then use the Get External Data / Import Text File option that is available under the Data menu to import the tabular data into Excel. This Excel function lets you choose the delimiter that the import will use. When importing numeric output files, both the Tab and the Space delimiters should be selected if the default delimiter is used in the numeric output. The delimiter used within the numeric output can be defined in the Header panel of the Analysis Properties dialog box.
By default, Micro-Cap will usually place a lot more information in the numeric output than just the tabular data of the waveform such as the operating point results for individual devices. This can potentially take up a large amount of the file and probably is not information that one would want to import into Excel. The Import Text File function in Excel lets you choose the first row to begin the import process on as a way to skip all of the other information and just import the tabular waveform data. Alternatively, in Micro-Cap, the Properties dialog box in the analysis provides a way to limit the type of information that is sent to the numeric output file. In the Numeric Output page of the Properties dialog box, disabling all of the options but Include Numeric Output and Include Waveform Values will result in a numeric output file with just the tabular waveform data.