Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[ChairmanPoo]

I have a data export from a program that comes in excel format, BUT, instead of placing data in separate columns, places it in the same one, separated by spaces

(AKA: you'd find inside the same column this number 1010223    500 (whereas normally 1010223 and 500 should be in separate columns).

Is there any way to make each number go to a separate column? Thanks in advance.

[wierd]

Try exporting as CSV format. Put a comma between pieces of data, and use a new line for each row.

(basically, CSV stands for Comma Separated Values. uses a comma as a column delimiting marker, and uses new lines of these seperated values for new rows.)

Should be easier to export, and will import into excel more reliably.

If push comes to shove, copy the "mashed" column cell data into notepad one row at a time, then use find/replace to convert " " into ",", which will make a CSV format document. save it as *.csv, then open it in excel.

[LordBucket]

Is there any way to make each number go to a separate column?

Text spilt to columns using a space as the delimiter. Here's a walkthrough. Note that the interface may be different than shown depending on your version of excel. If that tutorial looks nothing like what yours does, do a google search for "excel separating first and last names" plus whichever version you're running. This is a common issue. There are lots of how-tos for it.