First, make sure there are nine empty columns to the right of your column
with the data in it.........then highlight the column, and do Data >
TextToColumns > Delimited > and set "space" as the delimiter........practice
with a copy of your data, not the original. You may find that during this
process it will be advantageous to follow the menus and format certain of the
columns according to their data type. Once you do it a few times, it will
come easy......
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.