Hi
Here is how to split "any somewhat formatted" text file using Excel 2003*. The procedure has been the same since the early 1990'ies:
- Open the file in Excel
- When the "Text Import Wizard" shows
(Step 1 of 3)
- select fixed width, in the case of a S2P file otherwise it could be delimited with e.g. "space", ";", ",", "tab" ...
- select the row to start the import
- select the file origin. Sometimes this may require some experimentation to match the OS locale
- click the Next button
(Step 2 of 3)
- click the Next button
(Step 3 of 3)
- click the Advanced button
- select the decimal separator (S2P file = .)
- select the thousands separator (S2P file = ,)
- click the OK button
- Click the Next button
*: I don't know how it is done in later versions or other spreadsheet programs.
Another way to convert the decimal separator is to open the file in a text editor and replace the decimal separator.
Bo
Bo, OZ2M