Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list (.txt document) of telephonenumbers with first and surname and number.

Like this :

123123 john doe
123132 michael jordan


I want to put the list in microsoft excel that after a blank space means a new column

That I have a list like this :

number | firstname | surname
123123 | john      | doe
123132 | michael   | jordan

When I now paste my document into excel, number, firstname and surname are pasted into one column. What to do?

share|improve this question
up vote 2 down vote accepted

Two options:

  1. Doing it directly.

    a) Open a blank excel and go to 'Data' > 'From Text'.

    b) Browse for the document in txt and pick 'Delimited', Next.

    c) Uncheck 'Tab' and check 'Space'.

    d) Click Finish.

  2. Going from where you left:

    a) Select the whole column, go to 'Data' > 'Text to Columns' > 'Delimited', Next.

    b) Follow steps c) and d) from the first option.

share|improve this answer

Use the data --> convert tool to convert space /and/or tab into new columns: enter image description here enter image description here

Or you can import the data directly from text Data --> Import from text and choose space character as delimiter.

share|improve this answer

Your Answer


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.