0

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?

0

2 Answers 2

2

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.

1

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.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .