Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

An application that I use generates data in the form of a text file, with the values separated by spaces. When I load this into Excel, a column of data I'd like to extract is melded to several other columns, making one chunky supercolumn with too much data in it. It is structured like this:

[number] [word] [hyphen] [number]

If possible, I'd like to split this single column into four columns, one for each data entity. Every data entry is separated by a space. Is it possible to essentially replace the spaces with column dividers?

share|improve this question

2 Answers 2

up vote 3 down vote accepted

Excel has a Text to Columns feature that should be able to do that for you. Assuming you have Excel 2007 then select the column you want split, go to the Data tab and click Text to Columns. then select Delimited (Next) and then check only the Space option and click Finish.

share|improve this answer
    
Worked perfectly, thank you! –  moonslug Dec 3 '10 at 2:29

When you open the data file, you should be able to select Delimited and choose the column separators. Check "space" to add it to the delimiter set.

If none of your data has spaces inside each of your [number] [word] [hyphen] [number] columns, that should do exactly what you want.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.