How to Make 2 Columns in Notepad?

8 replies
I have a list of 4000 name & username Like this



Does anyone know any notepad code or excel code so that I can do this in right away.
#columns #make #notepad
  • Profile picture of the author jbmarwood
    I don't know.

    How about paste it into excel then use the autofilter. auto filter on "username" then copy those and paste into a new column. then delete them from the original column. Might work?
    Signature

    How to Beat Wall Street.
    Trading Systems & Strategies
    jbmarwood.com

    {{ DiscussionBoard.errors[9596644].message }}
  • Profile picture of the author Triplescan
    You are talking about notepad ++? Because if this is the case here you have it How can I view two files side by side in Notepad++ - Super User

    But if you refer to precisely notepad, the thing with two columns can't be done. Use Word instead.
    Signature
    {{ DiscussionBoard.errors[9596802].message }}
  • Profile picture of the author laurencewins
    Excel is the simplest way but you can do it with Word as well. Just make a table.
    Signature

    Cheers, Laurence.
    Writer/Editor/Proofreader.

    {{ DiscussionBoard.errors[9596939].message }}
  • Profile picture of the author John Rogers
    There's probably a way to create a macro that will accomplish that, but you'll have a better chance of finding your solution in a forum that discusses Microsoft Office. I'm pretty sure the answer involves Excel.
    {{ DiscussionBoard.errors[9597473].message }}
  • Profile picture of the author dariusdarius
    You should use Word or Excel, those should do the trick for you. Notepad by itself cannot do it.

    Darius Vaduva
    {{ DiscussionBoard.errors[9597484].message }}
  • Profile picture of the author Entrecon
    Put it into Word first and do a Find and Replace to get the items you want on the same line. (i.e. look for ^p"Username: and replace with "Username. Once you have everything on the same line, you can put it into Excel and get it into columns. You might need to use Text to Column,, You might also need to do some more find and replace in Word to get some more unified data that Excel can work with.
    Signature

    Visit My website http://kipferguson.com

    {{ DiscussionBoard.errors[9597571].message }}
  • Profile picture of the author akmaliskandar94
    you should use excel when working something like this. It makes it easier that any notepad software
    {{ DiscussionBoard.errors[9597616].message }}
  • Profile picture of the author jungleweb
    With Notepad you can use the space bar. You will have to do everything manually. Put Name: (then space however many spaces you want across). Then put Username. Then enter to go to the next line and repeat. Then when you're finished with everything just save it. But there are easier ways like several have mentioned such as excel and Notepad++.
    {{ DiscussionBoard.errors[9599150].message }}

Trending Topics