Results 1 to 8 of 8

Import textfile to excel and split (spaces) to column !

Threaded View

Petter120 Import textfile to excel and... 05-09-2012, 10:28 AM
Russell Dawson Re: Import textfile to excel ... 05-09-2012, 10:35 AM
AlvaroSiza Re: Import textfile to excel ... 05-09-2012, 10:40 AM
Petter120 Re: Import textfile to excel ... 05-09-2012, 10:40 AM
Russell Dawson Re: Import textfile to excel ... 05-09-2012, 11:00 AM
baldphil Re: Import textfile to excel ... 05-09-2012, 12:56 PM
baldphil Re: Import textfile to excel ... 05-09-2012, 01:08 PM
Petter120 Re: Import textfile to excel ... 05-09-2012, 02:04 PM
  1. #1
    Forum Contributor
    Join Date
    12-05-2008
    Location
    Kiruna
    Posts
    163

    Import textfile to excel and split (spaces) to column !

    Hi

    Is it possible to import a textfile whit VBA to excel and split every (space) to a column) ?

    Textfile
    Hello how old are you ? i am 22 years old
    Please help me im getting nuts

    Excel
    [ ] = Columns
    [A]Hello [B]how [C]old [D]are [E]you [F]? [G]i [H]am [I]22 [J]years [K]old
    [A]Please [B]help [C]me [D]im [E]getting [F]nuts

    I think you get the idea.

    Best regards

    Petter
    Last edited by Petter120; 05-09-2012 at 02:03 PM.

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