+ Reply to Thread
Results 1 to 3 of 3

Messy tab characters

  1. #1
    Registered User
    Join Date
    12-01-2005
    Posts
    4

    Messy tab characters

    Hi.

    I've got a list of words from another application. Whilst the tabs are tidy and neat in that application, when I paste them into excel they get all messed up.

    for example (imported file into excel)
    hello
    hej
    hej
    I
    jag
    car
    bil
    So the values are placed into many different columns. I just want them into to columns, like this:

    hello
    hej
    I
    jag
    car
    bil
    Does anyone have a clue of how to fix my file?
    I would deeply appreciate it!

    Damn! Not even this site can show the indentations properly!

    /Niklas B
    Last edited by Gargoyl; 04-18-2006 at 09:59 PM.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    try Data, Import External Data, Import data, locate you file (I presume these are saved as a .txt file) and set the Wizard to delimited and the delimiter to a character that will give you the correct format.

    Hope this helps

    --

    Quote Originally Posted by Gargoyl
    Hi.

    I've got a list of words from another application. Whilst the tabs are tidy and neat in that application, when I paste them into excel they get all messed up.

    for example (imported file into excel)
    hello
    hej
    I
    jag
    car
    bil
    So the values are placed into many different columns. I just want them into to columns, like this:

    hello
    hej
    I
    jag
    car
    bil
    Does anyone have a clue of how to fix my file?
    I would deeply appreciate it!

    /Niklas B

  3. #3
    MyVeryOwnSelf
    Guest

    Re: Messy tab characters

    > I've got a list of words from another application. Whilst the tabs are
    > tidy and neat in that application, when I paste them into excel they
    > get all messed up.
    >
    > for example (imported file into excel)
    >
    > hello hej
    > I jag
    > car bil
    >
    > So the values are placed into many different columns. I just want them
    > into to columns, like this:
    >
    > hellohej
    > Ijag
    > carbil
    >
    > Does anyone have a clue of how to fix my file?


    Maybe it would help to open the file in MS-Word first. Use Word to replace
    all the tabs with nothing. Opening the resulting file in Excel should give
    one column, which appears to be what you want.

    Or maybe you want multiple columns, but no empty cells in between. In that
    case, in Word you can replace tab-tab with a single tab, and repeat until
    you get no substitutions.

    As always, work with a copy of the file. If things donít go right, youíll
    still have the original.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1