How do I delete rows of characters in a body of text?

I have a list of over 1000 usernames I bought, and I am using them in a bot my friend created. The usernames have to be in the format of

Username
Username
Username
Username

But they are in the format of

1786 Username
1787 Username
1788 Username
1789 Username

I was wondering if there is any way to just delete a whole entire row of text. If you are able, perhaps I could give you the text document and you could help me out!!! Thanks guys...

Snowboard-Ninja.

 

First off, you mean an entire column...

1) Open your file with notepad.
2) Press Control+H or go to Edit -> Replace.
3) In the first box put " " and in the second box put "," (both without quotation marks - this will replace all the spaces by commas).
4) Save the file as whatever you want with a .csv extension (this identifies it as a comma separated value file).
5) Open your .csv file with Microsoft Excel or just about any spreadsheet viewer and it will separate the numbers into one column and the usernames into another column. Just copy the username column since that's what you want.

 

Pure genious!!!

Worked like a charm THANK YOU!

 

It's what I do.

 

that's new, and usefull, and i've never thought of that before and it might come in handy, and thx