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.

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

Like this :

123123 john doe
123132 michael jordan

etc.

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
add comment

2 Answers 2

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
add comment

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
add comment

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.