Results 1 to 2 of 2

Thread: Text file imported into Excel - Need help separating the data into two columns

  1. #1

    Text file imported into Excel - Need help separating the data into two columns



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have a text file that is imported into Excel. The information is all in one cell, in the first column. Looks like this:

    HGRISKO1,AADURAN
    AGRISKO,AEGRAFS

    I want to separate the two words into two columns and delete the comma. So it would look like this:

    AGRISKO1 AADURAN
    AGRISKO AEGRAFS

    Is there a fast way to do this? I have over 40,000 lines of text.

  2. #2
    Nevermind, I figured it out. I imported it by using the comma delimited feature.

Posting Permissions

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