How do I open space-delimited file in Microsoft Excel?

excel space delimited
merazuu picture merazuu · Feb 13, 2014 · Viewed 31.9k times · Source

When i try to open space delimited file in excel, the whole content opens in a single column. Is there any way to open the space delimited file in excel so that the delimited contents are properly formatted into different columns?

My scenario is that i have a file that needs the delimiter to be some thing like '" ' (A inverted command followed by a space), because my file format is like this:

"First Name" "Gender" "Phone" 
"Tom Jones" "M" "123-123-1234"

Answer

La-comadreja picture La-comadreja · Feb 13, 2014

Use the standard "Open" command. Then go to "Text Import Wizard" and choose that the original data type was delimited. You may need to go to a different step of the Wizard to specify that the delimiter is a space, but the Wizard does include the option of specifying what character the delimiter is.

Related questions

EXCEL VBA Check if entry is empty or not 'space'

Note. Check if the TextBox1 is empty is easy by using TextBox1.Value = "". But the problem is when the user hit the spacebar, TextBox1 will still recognize it as a value. In such case, my data will appear as an …

Read More
How to include space in XML tag/element which gets transformed by XSLT into Excel sheet

I have an XML which gets transformed with an XSLT into an Excel sheet on a webpage. The element tags in XML becomes column headers in Excel. There are columns which would like to have spaces. We don't like underscores …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More